How to use Excel : Excel Basics – How to navigate between different sheets in Excel


Introduction :

By default when we open Excel 2016 it shows up one worksheet to work with. Though we can change the default number of sheets shown to us at starting excel. But while working with excel we’ll always have to add new sheets to the workbook and navigate through them. To be able to work with excel profeciently one should be able to navigate between the cells of the worksheet and also between the different open worksheets. Here we'll discuss the different methods by which users can navigate between the open excel worksheets. But first we'll have a look on how one can add new worksheets and activate them for editing in Excel.

Add Sheets

Add new sheets to the workbook –

To add new sheets to the workbook simply click on the add new sheet button that is located on the immediate right of the current sheets tabs.

Navigate between Excel Sheets
Activate sheet

Activate a sheet for editing –

To activate a sheet for editing simply click on the sheet tab. This sheet now becomes the current sheet and is ready for editing.

Navigate between different sheets in an Excel Workbook

Given below are the different methods by which we can navigate between the different sheets in a workbook.

Method 1

Next sheet and Previous sheet buttons –

These are the ellipses ( … ) that appear on the left and right side of the sheet tabs section. By clicking on these buttons you can change the currently active sheet of your workbook. The next sheet button on the right of the sheet tabs activates the sheet next to the currently active sheet while the previous sheet button on the left of the sheet tabs activates the sheet previous to the currently active sheet.

Navigate between sheet tabs in Excel
Method 2

Sheet tab scroll buttons –

On the left side of the sheet name tabs we have the sheet tab scroll buttons. These are two triangle shaped buttons and are useful if we have a lot of sheets in the workbook. Just click on these buttons to view the hidden sheet tabs one by one. It won’t change the currently active sheet but just change the sheet tabs visible to you.

Navigate between sheet tabs in Excel

Note # Press Ctrl and then click on the Next scroll tab button to scroll directly to the last sheet tab. Similarly press Ctrl and then click on the Previous scroll tab button to scroll directly to the first sheet tab.

 

Method 3

Right Click on any of the sheet tab scroll buttons to view the activate dialog box which contains the list of all the sheets in the workbook.

Navigate between sheet tabs in excel

Conclusion : 

Often when we are working with large and complex worksheet, it is not possible for us to waste time on navigating between the cells and sheets. Hence it is very important that one becomes well versed in these navigation methods to be able to work profeciently with Excel.