Several years ago, I created my Complete Excel Shortcuts Workbook. It contains more that 250 keyboard shortcuts we can use when the workbook is active.
I created the workbook as a reference, because I didn’t know of any other source that had them all. I’m fairly certain that this workbook is complete, because thousands of people have downloaded it and I’ve added the few additional shortcuts that Excel users have sent my way.
Most Excel users use some of the shortcuts frequently, like Ctrl+C andCtrl+V. But here are five shortcuts that aren’t as well-known, and that I use almost daily. I think you’ll find them worth remembering:
To get help for a worksheet function
Suppose you need to read the help topic for a worksheet function, say the MATCH function. When you type…
…in your formula bar, you’ll see something like this:
Press Ctrl+A or click the icon where the red arrow points to launch the Function Arguments dialog for the function. This dialog gives you a form that you can fill in for each argument. The dialog also provides short help for the function and for each argument.
If you want more extensive help about the function, click the hyperlinked “Help on this function” text in the bottom-left of the Function Arguments dialog. Clicking this text is the fastest and easiest way I’ve found to launch the full help topic for any built-in worksheet function.
To change cell borders:
To apply an outside border to the selected area(s) of your worksheet, press: Ctrl+Shift+7
To remove all borders from the selected cells, press:
I don’t know of any other shortcut key combinations that can change borders without first launching the Format Cells dialog.
To format the selected object:
To launch the Properties or the Format dialog for the selected object (cells, drawing objects, chart objects, etc.), type: Ctrl+1
This shortcut is particularly necessary in charts, when it’s sometimes difficult to right-click an object in order to launch its Properties dialog. So, if necessary, select any object in the chart, push the up or down arrow—or the left or right arrow for finer control—until you select the object you want to format. Then type Ctrl+1 to launch the Properties dialog for the selected object.
To check the accuracy of a range name or other cell reference
Suppose you’ve written a formula that uses a range name that returns a cell reference, or a formula that uses a function that returns a cell reference (like OFFSET or INDEX). And suppose you now want to check that the reference actually points to the area you think it does.
For example, suppose you enter this formula…
…in a cell and you want to check that the OFFSET function really is returning the area you want to sum. To do so…
1. In your formula bar, select the text that returns the reference you want to check, like this:
2. Press Ctrl+C to copy the selected text.
3. Press Esc to return to the Ready mode.
4. Press Ctrl+G or F5 to launch the Go To dialog.
5. Press Ctrl+V to paste your copied text into the Reference edit box of the Go To dialog.
6. Choose OK.
When you do so, Excel selects the range to which the reference points. Here, for example, it would select the range A3:A4.
By the way, whenever you use the Go To dialog to select a new range, Excel sets up the range you’ve just left as the default range. Therefore, if you want to return to your original range, press Ctrl+G, Enter. To toggle back, press Ctrl+G, Enter again…and so on.