These ways include using the Double Underline command in the Font group, using the Double Underline and the Double Accounting commands in the Format Cells dialog box, and applying a Bottom Double Border to the bottom of cells. We have looked at different ways to apply the standard double underline and the double accounting underline to parts of a dataset. In accounting, the double underline is mainly used to highlight grand totals. We apply a double underlining format to areas of a dataset to make the areas stand out and thus make the dataset easier to comprehend. In this case, we may have to merge all the cells that contain the text so that the Double Accounting underline can extend to all the text. Click Home > Font > Underline Arrow > Double Underline.ĭouble underline is immediately applied to the value in cell B10 as displayed below.Select cell B10 which contains the Net income figure.To apply the double underline to the Net income value in the dataset so that it stands out, we use the following steps:
The Double Underline command is in the Font group on the Home tab. We will use the following example accounting dataset to explain the 5 methods we can use to double underline in Excel: Method 1: Use the Double Underline command in the Font’s group Method 4: Apply Bottom Double Border to the bottom of the cell.Method 3: Use the Double Accounting command in the Format Cells dialog box.Method 2: Use the Double Underline command in the Format Cells dialog box.Method 1: Use the Double Underline command in the Font’s group.5 Methods of Double Underlining in Excel.
0 kommentar(er)
