how to put a diagonal line in excel for mac

And what you get is a cell with a line drwan diagonally.Īnother way to achive the same thing is by pulling the format cell screen by clicking the little arrow under the group titled as FONT under the home tab.

Under the sub header titoled Border, where you see the various ways in which lines can be added to a cell, selct the diagonal line, lower left to upper right or upper left to lower right.whichever you need. 1) You have redefined your Normal style (or whatever style is applied) to contain a diagonal border - choose Format/Style to reset it.

Right click the cell and click on format cells.

Select the cell where you want to add a line diagonally.

Then format the cell with the diagonal line of choice, voila If you want an 'X' than select the opposite diagonal cells and the opposite diagonal line and presto, you have an 'X'.

Simply select the diagonal cell using the control key and the left mouse button. Simply select the diagonal cell using the control key and the left mouse button. Actually you can draw a slanted line through an area with a little work. If you need to draw line in PDF, such as drawing a straight line, diagonal line, dashed line in PDF, here are 4 easy solutions for you. In MS Excel 201O and later versions you can achive this by the following steps. Allen Quote 'Diagonal borders can only be applied to cells, not to rectangular areas you select onscreen.' Actually you can draw a slanted line through an area with a little work. But how do we add a diagonal line to a cell.!!! The simplest way to do this is to use the borders feature of a cell. Right-click the triangle and choose Edit Text.

Holding ALT makes the triangle snap to cell boundaries. Hold down the ALT key on the keyboard and draw the triangle in the cell. In the Ribbon, choose Insert > Shapes > Right Triangle. Many a times we feel the need to use a cell to act as headers for data flowing in two directions - Rows and columns and for this purpose we may want to add a diagonal line to accomodate the two headers. Insert a Shape You can divide a single cell diagonally in Excel by inserting a right triangle shape into the cell.

How to put a diagonal line in excel for mac