DOUBLE UNDERLINE IN EXCEL NOT BORDER HOW TOĬarlton Collins, CPA, discusses how to underline entries on an excel worksheet that don’t extend all the way to the edges of the cell. In excel there is a way to format cells with single and double underlines that don’t extend all the way to the edges of the cell, but extend past the text, eliminating the need to insert thin columns to create the space. Excel’s Accounting Format was designed for accountants, and it allows you to insert nontouching single and double underlines in adjacent columns.

Below are the five steps needed to apply this formatting:ġ.

Add double underlines. Highlight the total row, right -click on the row, select Format Cells from the pop-up menu, and then on the Font tab, select Double Accounting from the Underline dropdown box, then click OK.Ģ. Add single underlines. Highlight both the header row and the row above the total row (hold the Ctrl key down to select multiple ranges), right-click anywhere on the highlighted range, and then select Format Cells from the pop-up menu. Next, on the Font tab, select Single Accounting from the Underline dropdown box, then click OK.ģ. Format the numerical data. Highlight the numerical data, right-click anywhere on the highlighted range, and select Format Cells from the pop-up menu. Next, on the Number tab, select Accounting from the Category list box, set the Decimal places spinner to 0, select the dollar symbol ( $) in the Symbol dropdown box, and click OK.

DOUBLE UNDERLINE IN EXCEL NOT BORDER HOW TO.

Double underline in excel