Microsoft Excel: Double Underline A Grand Total

Problem: Your boss is a CPA. He says you should double underline the grand total in a report. As the results show in Fig. 1287, you only have an underline icon on the Formatting toolbar.

See all Microsoft Excel tips

Strategy: Select the Grand Total cell. From the menu, select Format – Cells – Font. In the Underline dropdown, choose double or double accounting. The cell will have a double underline, as shown in Fig. 1288.

Summary: You can add a double underline to a number, but you have to use the Font tab of the Format Cells dialog.

Commands Discussed: Format – Cells – Font – Underline

See all Microsoft Excel tips

Images

Related Article