Excel Tips

How to Use the Hidden Underline Formats in Excel

First, select the cell(s) to which you want to apply underline formatting.

To display the choices, go to: Home > Font Group (Click the downward arrow) > Format Cells > Underline. Clicking on the drop-down reveals all the choices you have. You can select any of five different underline types.

• None: Removes any underlining from the cell contents.
• Single: Adds a single underline which spans the width of the cell contents.
• Double: Adds a double-line underline which spans the width of the cell contents.
• Single Accounting: Adds an underline that is noticeably lower than the Single Underline. Also, the width of the underline spans the entire cell width if the cell contains text or dates.
• Double Accounting: Adds two lines that are noticeably lower than the Double Underline. Also, the width of the underline extends across the entire cell width if the cell contains text or dates.

Note : Single Accounting and Double Accounting underlines are accounting practices. Single Underlining is used to highlight subtotals and Double Underlining is used to markup the final total in any financial statement.

loading...