Technology Talk: Excel Shortcuts

By Lindsay Gill

April 14, 2014

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.