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.
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