Pinterest Pixel

Excel Sheet Navigator

A cool tip that most people may not know and one that is very very handy is... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Excel Sheet Navigator | MyExcelOnline Excel Sheet Navigator | MyExcelOnline

A cool tip that most people may not know and one that is very very handy is the what I call the Sheet Navigator.

If you have lots of worksheets in your workbook and you quickly want to navigate to the last worksheets, all you need to do is Right Click in the bottom left hand corner of your workbook where the sheet arrows are located and this will bring up a list of all your worksheets.

You can also flip back between worksheets but this cool trick is available via the Awesome Tab Hound Add-In.

Excel Sheet Navigator | MyExcelOnline

download excel workbook Sheet-Navigator.xlsx

STEP 1: Right-click on the sheet arrows
Excel Sheet Navigator

STEP 2: Select the sheet that you want to navigate to. Click OK

Excel Sheet Navigator

You have now jumped to your selected sheet in an instant!

Excel Sheet Navigator

Helpful Resource:

728x90

If you like this Excel tip, please share it
Excel Sheet Navigator | MyExcelOnline Excel Sheet Navigator | MyExcelOnline
See also  How to Create A Yearly Leave Record for Employees in Excel - The Easy Way
Founder & Chief Inspirational Officer at MyExcelOnline.com

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship Academy Online Course.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...