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 next to Font and then, in the Underline box, click the style that you want to use. To create an underline without any text in Microsoft Word, press Ctrl+U to start the underline, then, press Ctrl+Shift+spacebar to create non-breaking spaces.Press and hold this keyboard shortcut combination to add multiple underlines next to each other, creating an underline. To apply a single underline, click Underline. On the Home tab, in the Font group, do one of the following: You can also press F2 to edit the active cell, use the arrow keys to place the insertion point, and then use SHIFT+arrow keys to select the contents. If editing in a cell is turned off, you can click the cell and then select the text or numbers that you want to underline in the formula bar. If editing in a cell is turned on, you can select the cell contents by double-clicking the cell. To underline just a portion of the contents in a cell, double-click that cell, and then select the text or numbers that you want to underline. ExcelTips is your source for cost-effective Microsoft Excel training. In addition, the width of the underline extends the entire cell width if the cell contains text or dates.

Contents show Where is the double line style in Excel Right-click and then select Format Cells from the popup menu. The If statement below checks if the user selected the Single underline style from the drop down list: ElseIf Cells(1, i) 'Single' Then Range(Cells(2, i), Cells(2, i)).Font.Underline xlSingle. To underline all text or numbers in a cell or range of cells, select that cell or range of cells. Adds a double-line underline that is noticeably lower than the Double underline. 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.

How to add double underline in excel