Moving around Excel sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I go to end of the sheets in an Excel file, instead pressing Ctrl+Pg
Up. If excel file has 20 sheets, it is hard to press short cut 19 times. Is
there any short cut for this? Thanks.
 
How can I go to end of the sheets in an Excel file, instead pressing
Ctrl+Pg
Up. If excel file has 20 sheets, it is hard to press short cut 19 times.
Is
there any short cut for this?
Click to expand...

Click the tab for the sheet that you want with your mouse? <g>

Rick
 
Hi SB,

Try right click on the navigation arrows at the bottom left of your screen
and select the sheet you want.

HTH
Martin
 
In addition, if you can't see all the sheets tab , you may scroll sheet tab
with the four navigation arrows or drag the horizontal scroll bar to the left
side to accommodate more sheets tabs to view.

BTW you may download my add-ins "workbook navigation.xla" which has many
options working with large no. of sheets\workbooks from below site.


http://in.geocities.com/shahshaileshs/


Regards,

Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.
 
CTRL + pgup or pgdown one at a time is the only keyboard shortcut.


Gord Dibben MS Excel MVP
 
Back
Top