

33 Single accounting underline 34 Double accounting underline. Remove any border formatting in the cell and then, while the cell is still selected, click on FORMAT in the menu and select CELLS. In addition, the width of the underline extends the entire cell width if the cell contains text or dates. The default Excel 2007+ cell format is Calibri 11 with all other properties off. In addition, the width of the underline extends the entire cell width if the cell contains text or dates.Īdds a double-line underline that is noticeably lower than the Double underline. Removes any underlining from the cell contents.Īdds a single underline, the width of the cell contents.Īdds a double-line underline, the width of the cell contents.Īdds a single underline that is noticeably lower than the Single underline. In the Underline box, in the lower-left corner, you can select any of five different underline types. The Font tab of the Format Cells dialog box. Excel displays the Format Cells dialog box you should make sure the Font tab is visible. The Borders button looks like a square with four quadrants. Click the down arrow next to the Borders button. You can do this by clicking and dragging over the cells you want until they turn blue.

Select the cells you want a border around. Underlining of information within cells is handled by displaying the Home tab of the ribbon and, within the Cells group, clicking the down-arrow to the right of Format and choosing Format Cells. Double-click on any Excel sheet in your computer to open it up. There are several different types of underlines you can use in Excel.
