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 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. If you find you’re always using formatting commands only found in the Format Cells dialog box (Ctrl + 1), then these may be worth adding to your quick access toolbar. Select the Double underline option in the drop-down menu. Double Underline Subscript Superscript Excel’s ribbon has a lot of formatting commands but there are quite a few that are missing. You can also link it to a macro and assign a. Now you can with the styles list open, select text and assign that formatting by double clicking the style. Right click Default, select New, modify it to dotted underlining and close. In the Ribbon, on the Home tab, click the arrow next to the U button. Press F11, select the second icon from the left at the top of the styles list, that opens the character styles list. Also, if the AutoFormat option for changing underscore characters into border lines is turned on, pressing Shift+Hyphen (-) three or more times in a. You can underline blank spaces by pressing Shift+Hyphen (-), but it is difficult to line up the underlines if you are creating a fill-in form, for example. Highlight the text you want to double underline. Select double underline in the Underline style drop-down list. To underline all text or numbers in a cell or range of cells, select that cell or range of cells. The Ribbon in Microsoft Word provides an option to create double underlines for selected text.