In this video, I will show you 7 easy ways to quickly switch between sheets in Excel. While most people do this using the mouse, I cover methods that are better in most cases.
00:00 Intro
00:14 Switch Sheets using keyboard shortcuts
01:53 Switch Sheets using Watch Window
05:17 Switch Sheets using Activate Window
06:07 Switch Sheets using Name Box
08:37 Switch Sheets using Go to Dialog Box
10:52 Switch Sheets using Hyperlinks
13:17 Switch Sheets using VBA Macro
Here is the VBA code used in the video:
———————————————————————————————————–
‘This macro code has been developed by Sumit Bansal of
Sub SwitchSheets()
If ActiveSheet.Name = “Sheet1” Then
Sheets(“Sheet3”).Activate
Else
Sheets(“Sheet1”).Activate
End If
End Sub
———————————————————————————————————–
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee –
✅ Free Excel Course (Basic to Advanced) –
✅ Free Dashboard Course –
✅ Free VBA course –
✅ Free Power Query Course –
✅ Best Excel Books:
Subscribe to get awesome Excel Tips every week:
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Hi Sumit, thanks a ton for this video. I have been struggling with switching between multiple sheets till now. Your tips are a great help in saving time and working efficiently. Best regards
I learnt a new way in this video 'Watch Window' I have never tried this … I want to prepare an index sheet with hyperlink and connect all the sheets with one another … can you suggest the procedure… thanks in advance
Hi Sumit! Very nice tips. I especially liked the watch window. I try to avoid some clicking, and I use to remind users that the QAT can be activated by alt-x where X is the position of the actual icon. Then you can activate your switch sheet macro even faster. Try it!
Good one
It's very basic information, but useful for leaders, please do on MIS -Reportings for Accounting and Finance professionals,
Thanks sharing your valuable knowledge,
Good topic , now I can get rid of page up and down. Thanks
I really learned a lot from your videos. I have been appreciated by my supervisor because of the skill up from your teachings. Can you upload videos on DAX, others don't explain the way you do