Navigating Between Excel Worksheets and Files

Here is one area of Excel (like many others) where it’s far more efficient to use the keyboard than the mouse. Here are the basic shortcuts for Navigating Between Excel worksheets in a file, or between files. These shortcuts will also work when creating a formula.

CTRL + Page Dn: Move to the worksheet to the right (best to use the right CTRL key)

CTRL + Page Up: Move to the worksheet to the left (best to use the right CTRL key)

CTRL + Tab: Move to another open Excel file (best to use the left CTRL key)

If you enjoyed reading this article and want to improve your Excel Skills further, then why not try our Excel Best Practices for PC Self-Study Course. You can also browse our other range of Self-Study Courses here.

Training The Street also offers a more advanced In-Person/Virtual Public Course called, Applied Excel. Where you can gain the skills needed for parsing, analyzing, and presenting information from large data sets.

Browse our other Resources: