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

Scroll To The Last Sheet

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.

Activate Sheet

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.

Activate Sheet

Below you can check out the video describing on how to use the Activate Sheet command in Excel.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 8, 2016, in Excel 365 English, Microsoft Office 365 ProPlus English and tagged , , , , , , , , , , , . Bookmark the permalink. Comments Off on Activate Worksheet in Excel.

Comments are closed.