Working With Multiple Tabs In Excel - Tricks And Shortcuts To Improve Efficiency
We cover tricks and tricks to navigate an Excel workbook that has many sheets or tabs. In our example, we have a financial model that contains multiple sheets which can make it difficult to navigate them and have an overview of what is going on. The tips we cover include how to: navigate from tab to tab using shortcuts, activate sheets to view all at a glance, display the first or last group of sheets in the workbook, hide and unhide sheets, copy sheets using a shortcut and select multiple sheets at once.
DISCLAIMER: This video includes a financial model which is out of date and should not be considered for investment purposes. The sole purpose of the financial model is to demonstrate how to work with multiple tabs in Excel.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Working With Multiple Tabs In Excel -...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Tip 1 - Navigation using shortcuts: (0:31)
Tip 2 - Activating sheets: (1:10)
Tip 3 - Displaying first or last group group of sheets: (1:41)
Tip 4 - Hiding and unhiding sheets: (2:08)
Tip 5 - Copying sheets using a shortcut: (2:47)
Tip 6 - Selecting multiple sheets: (3:10)