docs / articles / Excel Shortcut Keys: Switch Between Sheets Instantly

Excel Shortcut Keys: Switch Between Sheets Instantly

Sara Jul 09, 2026 2026-07-09 04:40:45

Mastering shortcuts in Excel can significantly boost your productivity. One particularly useful set of shortcuts allows you to shift between worksheets effortlessly. Let's delve into these time-saving keyboard commands.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

Before we begin, ensure your Excel version supports these shortcuts. Most modern versions, including Excel 2016, 2019, and Office 365, do. Now, let's explore these handy shortcuts.

Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet

Basic Shortcuts for Navigating Worksheets

These fundamental shortcuts are the building blocks for more complex navigation.

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

First, let's learn how to switch between worksheets using the Ctrl + Page Up and Ctrl + Page Down keys. Pressing Ctrl + Page Up moves you to the previous worksheet, while Ctrl + Page Down takes you to the next one.

Ctrl + Page Up and Ctrl + Page Down

Microsoft Excel Shortcut key
Microsoft Excel Shortcut key

To use these shortcuts, simply press and hold the Ctrl key, then press the Page Up or Page Down key. Repeat as needed to navigate through your workbooks.

Here's a quick example: To move from Sheet1 to Sheet3, press Ctrl + Page Down twice.

Ctrl + Number Key

Excel shortcut ...✅
Excel shortcut ...✅

Another efficient way to switch worksheets is by using the Ctrl + Number key combination. Each number corresponds to a worksheet in the order they appear in the workbook.

For instance, pressing Ctrl + 1 takes you to the first worksheet, Ctrl + 2 to the second, and so on. If you have more worksheets than numbers on your keyboard, you can use Ctrl + Shift + Number to jump to the corresponding worksheet.

Advanced Shortcuts for Efficient Navigation

Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips
Excel Shortcut Keys #viral #trick #computer #exceltricks #ExcelTips

Now that you've mastered the basics, let's explore some advanced shortcuts for quicker navigation.

First, let's learn how to cycle through worksheets in reverse order using the Shift + F6 key combination. This is particularly useful when you need to revisit a worksheet you've recently left.

an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white
Computer tricks😉
Computer tricks😉
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel ctrl shortcuts cheat sheet
the excel ctrl shortcuts cheat sheet
a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
the different types of shortcut keys are shown in this chart, which shows how to use
the different types of shortcut keys are shown in this chart, which shows how to use
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
the google sheet shortcut keys are shown in different colors and sizes, including blue, yellow
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
Credits to Josh Aharonoff, CPA Follow him for more content. | Excel for CFOs
Credits to Josh Aharonoff, CPA Follow him for more content. | Excel for CFOs
excel useful shortcuts
excel useful shortcuts
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 20 Advanced Excel Shortcut Keys You Should Know
Microsoft Excel Shortcut Keys Cheat Sheet for Beginners & Office Work
Microsoft Excel Shortcut Keys Cheat Sheet for Beginners & Office Work
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
Excel Shortcuts: Ctrl and Shift Plus
Excel Shortcuts: Ctrl and Shift Plus
Excel shortcuts
Excel shortcuts
Excel shortcuts
Excel shortcuts
an open notebook with the words all excel shortcuts on it
an open notebook with the words all excel shortcuts on it
Excel Shortcut Keys | Easy Tricks for Beginners
Excel Shortcut Keys | Easy Tricks for Beginners

Shift + F6

Pressing Shift + F6 cycles you through your worksheets in reverse order. Each press takes you to the previous worksheet. To cycle forward again, simply press F6 without the Shift key.

For example, if you've been working on Sheet5 and want to go back to Sheet3, press Shift + F6 twice.

Ctrl + E, S, or T

Lastly, let's explore some lesser-known shortcuts for quick navigation. Pressing Ctrl + E opens the 'Go To' dialog box, allowing you to input a specific cell reference to jump to. Ctrl + S takes you to the last cell with data in the current column, while Ctrl + T jumps to the last cell with data in the current row.

These shortcuts are particularly useful when you're working with large datasets and need to quickly navigate to specific cells or the end of a row or column.

Mastering these shortcuts takes practice, but the time you'll save in the long run is well worth the effort. So, start incorporating these keyboard commands into your Excel routine today, and watch your productivity soar. Happy navigating!