In this blog we will see how we can quickly select sheet using single click when we have large number of sheets in the excel file. This shortcut will save your time in selecting a sheet without traversing all the sheets using arrow buttons.
As shown in screenshot below we have large number of sheets and it time consuming to select sheet 20 by traversing from sheet 1 to sheet 20. We can select sheet within fraction of seconds using this method.
- Press mouse right button on the arrow keys.
- It will open up a pop with a list of all the sheet names. Select the sheet and press OK, it will open up the selected sheet in excel file.
No comments:
Post a Comment