In addition, the width of the underline extends the entire cell width if the cell contains text or dates.Īdds a double-line underline that is noticeably lower than the Double underline. Highlight the total row, right-click on the total 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. Removes any underlining from the cell contents.Īdds a single underline, the width of the cell contents.Īdds a double-line underline, the width of the cell contents.Īdds a single underline that is noticeably lower than the Single underline. 33 Single accounting underline 34 Double accounting underline We can format data for double accounting underline using the below code: 1. Python integrates with Microsoft Excel very well.
In the Underline box, in the lower-left corner, you can select any of five different underline types. Usually, DBAs share export required data in an Excel sheet, do the formatting, and share it with the concerned authorities. The Font tab of the Format Cells dialog box. Excel displays the Format Cells dialog box you should make sure the Font tab is visible. Underlining of information within cells is handled by displaying the Home tab of the ribbon and, within the Cells group, clicking the down-arrow to the right of Format and choosing Format Cells. Every accountant must be able to double under the border on a total column in a financial presentation and a bold single border underline is also used extensively in the presentation of financial statements. If I use underline then just the numbers are underlined and not the border.
To apply a different style of underline, such as a double underline or a single or double accounting underline (an underline that fills the width of a cell), click the Dialog Box Launcher. These choices are available in Excel under the borders box. There are several different types of underlines you can use in Excel. How do you Underline text in Excel On the Home tab, in the Font group, do one of the following: To apply a single underline, click Underline.