Skip to main content
AmigoFish

Make Excel Feel Like an App (4 Secret Navigation Tricks)

From Leila Gharani Ā· Ā· 9 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Stop scrolling through big Excel files. Here are 4 ways I jump to any sheet in seconds. šŸ“„ Download the practice workbook: https://www.xelplus.com/navigate-excel-workbooks/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=download-navigate-excel&utm_content=navigate-excel-workbooks#download

šŸŽ“ Build solid Excel skills with Excel Essentials (500,000+ enrolled in our courses): https://www.xelplus.com/course/learn-excel-essentials/?utm_source=yt-video&utm_medium=vid-description&utm_campaign=essentials&utm_content=navigate-excel-workbooks

šŸ¢ Team licenses: https://www.xelplus.com/business-customers/

In this video, I show you 4 ways to move around large Excel workbooks. You'll see the hidden right-click sheet list, the Navigation Pane, a clickable navigation menu built with hyperlinks, and Name Box bookmarks. The clickable menu is my favorite. I add a back to summary link on every sheet, then build a flag sidebar that makes the file feel like an app.

āœ… Good to know: The Navigation Pane is available in Excel for Microsoft 365 on Windows and Mac. In the video I say Ctrl + Page Up moves down. To be clear: Ctrl + Page Up goes to the previous sheet, and Ctrl + Page Down goes to the next sheet. Name Box names can't have spaces or look like a cell address (UK1, for example). Use an underscore to join words.

ā±ļø Chapters: 00:00 Navigate big Excel workbooks without scrolling 00:40 Secret right-click sheet list 01:12 Navigation Pane (Microsoft 365) 01:47 Open the Navigation Pane from the status bar 02:06 Clickable navigation menu with hyperlinks 03:38 Add a back to summary link on every sheet 04:37 Build a navigation sidebar with flag icons 08:03 Name Box bookmarks 09:12 Edit or delete names in Name Manager

šŸŽ¬ Related videos: Create an Excel Dashboard to Easily Track Budget and Actuals with Variances: https://youtu.be/lHk6MdGAfw8 Learn to Automate Everything with Power Query in Excel: https://youtu.be/x7mzOYEn0XA

āž”ļø Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join šŸ‘‰ Get one practical Excel tip each week in our newsletter: https://link.xelplus.com/yt-d-newsletter

🚩 Connect with us: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/in/leilagharani

#excel #exceltips #exceltricks

Back to Leila Gharani Ā· Report a problem