Useful Excel keyboard shortcuts
Posted
by Ben Lings
on Super User
See other posts from Super User
or by Ben Lings
Published on 2009-08-06T09:53:49Z
Indexed on
2010/03/11
20:24 UTC
Read the original article
Hit count: 871
excel
|keyboard-shortcuts
What keyboard shortcuts do you use in Excel?
Things I've discovered recently and found very useful are:
- Shift + Space - select the current row
- Ctrl + Space - select the current column
- Ctrl + Shift + Space - select the block of contiguous cell
- Ctrl + + - Insert (as in the context menu). If the current row is selected, will insert a new row.
- Ctrl + - - Delete (as in the context menu). If the current row is selected, will delete entire row.
What (apart from the normal cut, copy, paste, etc) do you use?
Ctrl + 1 to open the Format dialog.
Shift + F2 to add/edit a cell comment.
Shift + F2, followed by Esc to select the current cell comment, which can then be moved around with the arrow keys (????) or deleted by pressing Del.
Ctrl + ???? to move to the last non-blank cell in a series. This is usually the edge of a table, but not if you have blank cells in the path. Pressing End followed by an arrow key does the same thing.
Alt + F11 to open the VBA editor.
Alt + = to start a SUM()
formula and go straight to selecting cells to be summed.
Ctrl + G or F5 to jump to a cell by typing its coordinates (e.g. C3
)
Ctrl + Home to jump to the top left, usually A1
unless you you are in a frozen split view, in which case it will jump to the top left of the "data" area.
Ctrl + ; and Ctrl + Shift + ; to insert the current date and time, respectively. I know Ben Lings already posted this one, but I find it indispensable.
© Super User or respective owner