In my example, I needed to add a dividing line in the top left cell separated Name and Sales in a way that made it clear Names went in Column A and Ages were part of Row 1. We’ll repeat that for this example.
Open a Blank workbook in Excel.
You can do this in any size of cell, but it’s easier to understand if you make it larger first. To do that, we’ll just click and hold the line between Row 1 and 2, and then drag until it’s at the desired height. Then do the same for the column to expand it horizontally.
Right click the cell and select Format Cells.
At the top, click the Border tab.
And then choose the diagonal line option at the bottom right of the menu. You can choose to draw your line in the opposite orientation by clicking the other diagonal line icon on the lower left of the menu.
Click OK.
Now type the text you want at the top of your diagonal line and press Alt + Enter to move to a new line.
Type the text on the bottom, and then press enter.
If the formatting is off, just double click within the cell and use the spacebar to move the top text over.
Microsoft Excel Tips
Previous TipNext Tip
Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special
