Tips for faster worksheet navigation - Excel Tips and Tricks - video Dailymotion

RobertBarone

This is a tip for faster worksheet navigation, In another words, how to quickly move between sheets in Excel. Sometimes the question asks how to switch between sheets in Excel or how to move around and between worksheet tab in Excel.  I will also show you the shortcut to switch between sheets.   Method 1  Click on Sheet Navigation button (bottom left hand side of the sheet)   Method 2  Shortcut to switch between sheets  Ctrl + Page UP and Ctrl + Page Down   Method 3  Sheet Activate  Right-click on any of the Sheet Navigation button, and select the sheet you want and click on OK.    Tips for faster worksheet navigation,Quickly move between sheets in Excel,How to Switch Between Sheets in Excel,How to Move Around and Between Worksheet Tabs in Excel,excel shortcut to switch between sheets,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00In your Excel workbook, if you want to navigate between sheet, use this arrow key here.

00:04If you click this arrow, you'll go to the previous worksheet and you select the sheet that you want to go to.

00:10And if you want to go to your current or your next sheet, you click on this arrow here and then you go to the sheet that you want.

00:16But this is really slow. As you can see, you have to click a million times before you get to your position,

00:21especially if you have multiple sheets like this.

00:24There's another way to do it, is to hold down the control key and page up like this.

00:28As you can see, it navigates to the previous sheets like this.

00:33If you press the control and page down, you'll go to the current and the next sheet like this.

00:39But that's another way we can navigate even faster than that.

00:43Right click any of this arrow here, a pop-up window will appear.

00:46And then select the sheet that you want to go to. Let's say I want to go to a really, really early sheet here.

00:51Say 15 and click OK and you'll navigate to sheet number 15.

Tips for faster worksheet navigation - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended