In case you want a double-underline, you can click on the ‘Border style’ option and then click on the double border option. The underline I am looking for is under the Font tab (and then in the Underline drop down menu) after clicking ctrl + 1. This would give a bottom border to the cell, which looks as if you have underlined the cell. Excel Tutorial to Learn Microsoft Excel Formulas, PivotTables, Sorting, Filtering, Remove Duplicates, Filtering, Deleting Rows, Inserting Rows & Columns. Is there a shortcut or hot key for single accounting underline To be clear, I am not looking for a border underline. Select the cell that you want to underline (in case you select a range of cells, only the bottom ones would be underlined).
This is often the case when presenting the sum of a column (or any other such calculation) and show some difference between the data and the cell that has the calculation.īelow are the steps to underline a single cell The combination of bold, italic, and underline furnishings really make the information more than readable. In the example below, you tin can run into a simple financial statement for a freelancer, earlier and later I utilise basic formatting. In some cases, you may not want to underline the text but the entire cell. Adding an underline is ideal for a summary prison cell, similar a subtotal or decision. The above steps would underline the selected text in the cell.
The keyboard shortcut to underline in Google Sheets is Control + U (hold the Control key and press the U key), or Command + U if using a Mac Underline Specific Text in a Cell