To apply a single underline, click Underline. Under Editing options, make sure there is a tick against Typing Replaces Selected Text. On the Home tab, in the Font group, do one of the following: Underscores for Access Keys and Underlined Text Not Showing. press DEL If solved, please mark it as 'Answers' & 'Helpful'. But if you dont like the continuous line that creates, the accounting underline is. you will see all of them listed in the window below. inserting text into certain part of text file. Most people use a bottom cell border on column headings or under totals. underlining text for specific nodes in a treeview.
#How to delete an underline in excel how to
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. How to maintain Bold font and underline in Text replacement. 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. You can use REPLACE to remove text by providing an empty string () for the newtext argument. If editing in a cell is turned on, you can select the cell contents by double-clicking the cell. The REPLACE function will replace text by position. 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.
To underline all text or numbers in a cell or range of cells, select that cell or range of cells.