�鶹������ý

‍

The list of shortcuts below are the shortcuts I show to my students in my Excel classes. Per a student’s recent suggestion I decided to compile them all into one document. If you’ve been in my class, then welcome back, these are for you! If you haven’t been in my class before, you’ll get plenty of use out of these when using Excel. **You can scroll to the bottom of this blog to see tutorials on how to use each keyboard shortcut.

Moving around

Navigate to end of data                                Ctrl + ↔↕

Navigate back to the beginning                 Ctrl + Home

Move between sheets                                  Ctrl ­+ Page Up / Page Down

Move between open workbooks             Shift + Tab

Selecting Stuff

Select a line of data                                         Ctrl + Shift + ↔↕

Select your whole data set                          Ctrl + A

Expand your selection by one                    Shift + ↔↕

Executing

Execute and move to the right                   Tab

Execute and move down                              Enter

Execute and stay                                             Ctrl + Enter

Other Useful Shortcuts

Make Absolute (lock or anchor)                F4

Insert today’s date                                          Ctrl + ; (semi-colon)

Basic Shortcuts (not specific to Excel)

Copy                                                                      Ctrl + C

Paste                                                                     Ctrl + V

Undo                                                                     Ctrl + Z

Redo                                                                     Ctrl + Y

Select multiple adjacent cells                      Shift

Select multiple non-adjacent cells            Ctrl

Tutorials

Navigate to the end of your data set

Ctrl + Directional Keys (arrows on your keyboard)

Select a whole line of data inside a data set

Ctrl + HomeNavigate back to the beginning (go to cell A1)

Select your whole data set!

Ctrl + A

Select an entire column

Ctrl + Spacebar

Select an entire row

Shift + Spacebar

Insert a row or column

Ctrl + Shift + “+”

** Make sure you already selected an entire row or column.

Remove a row or column

Ctrl + “-”

** Make sure you already selected the entire row or column.

Expand a selection by one cell, or one row, or one column

Shift + Directional Keys (arrows on your keyboard)

‍