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

Advertisements

The URI to TrackBack this entry is: https://powertipsntricks.wordpress.com/2011/03/26/sheet-tabs-navigation-in-excel/trackback/

RSS feed for comments on this post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: