I was recently surprised to learn at a team meeting that my peers were not as familiar with the many Excel shortcuts that I apparently take for granted. Urged by our team to share more, I decided I should share a few of the more frequently used Excel shortcuts with you:
CTRL + Page Down
Moves to the next tab(s) (right to left) in an Excel workbook
CTRL + Page Up
Moves to the previous tab(s) (left to right) in an Excel workbook
CTRL + Home
Moves the cursor to the beginning of the worksheet
Note: if you are using a screen lock function the cursor will be moved to the first cell below the screen lock.
CTRL + Shift + End
Selects (highlight) all cells from the current position of the cursor to the beginning of the worksheet.
CTRL + End
Moves the cursor to last cell in the worksheet
If the cursor is in the formula bar when pushing CTRL + End, the cursor moves to the end of the text in the formula bar.
CTRL + Shift + End
Selects (highlight) all cells from the current position of the cursor to the end of the worksheet
CTRL + Spacebar
Selects the entire column in a worksheet
Shift + Spacebar
Selects the entire row in a worksheet
CTRL + F
Opens the Find and Replace dialog box
CTRL + G
Opens the Go To dialog box
CTRL + C
Copies the selected cells
CTRL + X
Cuts the selected cell
CTRL + V
Inserts (paste) the current content on the clipboard. Note this will replace the current contents.
CTRL + Arrow Key
This will move to the edge of the current data range.
Example: When working with the data range below. If your cursor is in A1 and you press CTRL + down arrow your cursor will move to cell A7 (Sunday). Pressing the combination a second time would move the cursor to cell A9 (January). This is helpful when trying to locate the gaps in a sequence of data.
CTRL + B
Applies or removes Bold formatting to the current selection
CTRL + U
Applies or removes the Underline formatting to the current selection
CTRL + I
Applies or removes the Italic formatting to the current selection
This list barely begins to scratch the surface on the shortcut keys available in Excel. A simple Google search will reveal a treasure trove of shortcuts.