This is an update of a post from December 2010. Shortcut Keys for Locating Character Formats Ctrl+Shift++, - Apply superscript formatting Ctrl+Shift+W, - Word underline Ctrl+Shift+D, - Double-underline. Note that you can select an entire row by clicking the row number at the left of the sheet, or you can select an entire column by clicking the column letter. Step 2: Select the cell (s) to which you want to apply the double underline formatting. Reapply the filter and sort on the current range so that changes you've made are included. When an object is selected, CTRL + SHIFT + SPACEBAR selects all objects on a worksheet. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps. Step 1: Open the spreadsheet containing the value (s) that you wish to double underline. CTRL + SHIFT + SPACEBAR a second time selects the entire worksheet. 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. Undo last command with Ctrl+Z or Alt+Backspace. (If you underline first, it won’t work.) In Excel this is called Accounting Underline. 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. 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. But that is tedious to set up and interferes with using the ctrl+arrow or End+arrow keyboard shortcuts. Go to Tell me what you want to do, Alt + Q Zoom, Alt + W, Q, Tab to value you want Select an entire word, Double-click anywhere in the word Select an. 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. Step 3: After the option is added in a new tab, this will appear below in the ribbon. Step 2: From the options tab, choose to add New Tab and choose the Strikethrough option and click on OK. Most people that I’ve shown this to are just as surprised as I was when someone first showed me. Step 1: Right-click on the Font tab and choose the option of Customize the ribbon. Today’s Excel tip is very simple, but it can save a lot of time when formatting a spreadsheet.