How to add a bottom underline in excel update#
This is an update of a post from December 2010. And for totals, select your cell(s) and click the down arrow next to the underline button on the ribbon, You’ll find a choice there for double underline. You can see the resulting line will extend the entire width of the cell and not just the width of the text inside the cell. (If you underline first, it won’t work.) In Excel this is called Accounting Underline. Select the cell you want to add a bottom border to click on the grid icon in the command bar select the Bottom border option. Or will it? If you first format cells with either the comma format or the accounting format and then format the text as underlined, the underline will extend almost the entire width of the column. 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.
Click Insert > Module, and paste below code to the blank script Module. Press Alt + F11 keys to enable Microsoft Visual Basic for Applications window. Other Font dialog box options Once you are in the Font Dialog box, notice that you have a lot of other options to work. Obviously, there is no built-in function in Excel that can help you to add border line below when value changes, but there is a VBA code I can introduce. You could format the text in the headings to be underlined, but then the line will only be as wide as the text or numbers in the cell. Within the Font Dialog Box, open the Underline Style drop-down and from the options and select the double underline style you want to add to your text or numbers.
How to add a bottom underline in excel how to#
But that is tedious to set up and interferes with using the ctrl+arrow or End+arrow keyboard shortcuts. See how to align and justify text in Excel horizontally or vertically, fill cell with the current contents, align a column of numbers by decimal point or specific character. A common solution is to have very narrow empty columns between the columns of data. But for totals or subtotals, many people don’t like the continuous line that it creates they would prefer a separate underline in each column. Putting a bottom border on a row of cells can be a good choice for column headings on a spreadsheet. If you want a double underline, you must display the Home tab of the ribbon and use the down-arrow at the right of the Underline tool. Most people that I’ve shown this to are just as surprised as I was when someone first showed me. Everyone knows that you can underline text by simply selecting what you want underlined and then clicking on the Underline tool on the ribbon or toolbar. Today’s Excel tip is very simple, but it can save a lot of time when formatting a spreadsheet.