Activate Worksheet in Excel
Many times we have a Workbook in Excel that contains many Spreadsheets. Navigating among these Spreadsheets is very hard and time consuming. So what do we do then? Thankfully in Excel there is the Navigate command, which makes it very easy to navigate between the sheets, along with some shortcut keys.
If we navigate at the bottom left corner of our Excel Workbook, we will notice some shortcut keys in order for us to navigate among our Sheets. These shortcut keys are:
Ctrl + Left Click: We Will Scroll To The Last Sheet
Right Click: We Will Sell All Sheets
In the image below we can see the Sheets that are in our Workbook. Unfortunately, we cannot see all of them, which means in order to navigate to some of them will be time consuming by using the Click Mouse way.
In order for us to navigate quickly and easier is to move to the bottom left corner of the Workbook and do a right click with our mouse. Once done, the Activate dialog box appears, which contains all the Names of the Sheets that are in the Workbook.
All we have to do is to select the Name of the Sheet that we want to activate and then press the OK button and straight away the selected Sheet Is activated.
Below you can check out the video describing on how to use the Activate Sheet command in Excel.
Posted on March 8, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged #tips4msword, Activate Sheet, Activate Worksheet in Excel, Ctrl + Left Click, Microsoft Excel 2016, Microsoft Office 2016, Name of the Sheet, Office System, Right Click, Sheets, Smart Office, Workbook. Bookmark the permalink. Comments Off on Activate Worksheet in Excel.