Enhance your proficiency with practical key combinations that facilitate various operations such as opening, closing, saving workbooks, copying, pasting, and cutting, among others.
This article is not an exhaustive list of shortcut keys, but it is a great start for using shortcuts!
All key combinations are NOT case-sensitive.
You can close a workbook with Ctrl/W
You can open a workbook with Ctrl/O
You can save a workbook with Ctrl/S
Copy, Paste, Cut is Ctrl/C, Ctrl/V, Ctrl/X
You can undo the last thing(s) done using Ctrl/Z
To delete a column, you can press Ctrl/- when the entire column is selected, or press Alt/H,D,C. If one cell is selected and you press Ctrl/-, you’ll see this dialog:
Choose the one which you want to delete.
To insert a column, you can press Ctrl/+ when the entire column is selected, or press Alt/H,I,C. If one cell is selected and you press Ctrl/+, you’ll see this dialog:
Choose the one which you want to insert.
To move one cell to the right, you can hit the Tab key or press the right arrow. If you have more than one cell selected, repeatedly pressing tab will move the cursor to the right within the selection and then on to the next row. If A1:C2 is selected and you press the Tab key, this will be the selected cells in order: A1, B1, C1, A2, B2, C2. Shift/Tab will go in the reverse order.
Ctrl/End will take you to the last used cell on the worksheet. In this screenshot, Ctrl/End will select D4, even though nothing is in that cell:
To select cell A1, Ctrl/Home will do it (unless the panes are frozen or split, in which case the top left cell of the lower/right pane will be selected. Here, pressing Ctrl/Home will select cell D7!
To move to the next sheet tab to the right, Ctrl/Page Down. To move to the next sheet tab to the left, Ctrl/Page Up.
To move to the edge of a group, Ctrl/Arrow key. For example, in this screenshot, if the cursor is in A1 and you press Ctrl/Right arrow, you’ll wind up at C1. Do it again, and you’ll be at E1. Again, G1. Again, XFD1.
From A1, Ctrl/Down arrow successively will take you to A5, A9, A13, A1048576.
When the shift key is held down, getting to any other cell will leave the active cell still active. So in the above figure, if you hold the shift key and click on C3, the selection will be A1:C3 and A1 will still be the active cell. If you press F5 (go to) and type in C3 but hold the shift key down before clicking OK, A1:C3 will also be selected. If you hold the shift key while pressing the Ctrl+arrow key, A1 will still be active. For example, again in the above figure if you press Shift/Ctrl/Down arrow, the selection will be A1:A5, with A1 being active.
Pressing Ctrl/1 will bring up this dialog, giving you access to all the formatting:
To add a cell note, press Shift/F2
To create a Table, press Ctrl/T or Ctrl/L (L for List – lists used to exist before tables)
To enter the time, Ctrl/:
To enter the date, Ctrl/;
Ctrl/` will toggle between showing formulas and showing values. That is, in one case you might see 7, and in the other, you might see =3+4.
Ctrl/6 is a toggle to show or hide objects.
Fill down is Ctrl/D
Fill right is Ctrl/R
Apply %-format is Ctrl/% (Ctrl/Shift/5)
Date format (d-mmm-yy) is Ctrl/# (Ctrl/Shift/3)
Number with 2 decimal places is Ctrl/! (Ctrl/Shift/1)
Check Spelling is Ctrl/F7
If you’ve done a copy command, you can invoke the paste special dialog with Ctrl/Alt/V
Insert a hyperlink with Ctrl/K
Alt/Enter while editing a cell puts a new line in the cell
You can select a column with Ctrl/Spacebar, or select a row with Shift/Spacebar