Saturday, March 26, 2011

Sheet Tabs Navigation In Excel

If you created a large workbook in Microsoft Excel and having problem to navigate sheet tabs then, there is two solutions to this:
  1. Right click on one of the arrows to the left of the sheet tabs, a list will appear that contains the names of all the tabs in current workbook. You can then select a tab from the list and this will takes you to the tab.
  2. Use Ctrl + Page Down to move forward a worksheet.  Ctrl + Page Up moves backwards.  Ensure Num Lock is off.
Happy Navigation of Sheet Tabs!!

ILYAS QASIM

No comments:

Post a Comment