In this video we discuss how to quickly find, or scroll through all of the worksheets in a workbook in excel. We go through a detailed example of how to do this.
Transcript/notes
Let’s say that you have a lot of worksheets in a workbook in excel, like in this example workbook I have on the screen, and you want to quickly scroll through and find one of these worksheets.
To do this, go down toward the bottom left corner of the worksheet and hover over one of the arrows and a pop box will appear. As you see, if you right click, a list of the names of all of worksheets will appear in another pop up box.
From here, you can left click on the worksheet you want, then click on OK, and now you are in the worksheet.