Moving around Excel sheets
 

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.

Moving around Excel sheets
 

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 the tab for the sheet that you want with your mouse? <g

Rick

Moving around Excel sheets
 

Hi SB,

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

HTH
Martin



"SB" wrote in message
...
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.

Moving around Excel sheets
 

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.


"SB" wrote:

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.

Moving around Excel sheets
 

Of course I can move with mouse :) but how can I move sheets with using
keyboard only?

"Rick Rothstein (MVP - VB)" wrote:

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 the tab for the sheet that you want with your mouse? <g

Rick

Moving around Excel sheets
 

CTRL + pgup or pgdown one at a time is the only keyboard shortcut.


Gord Dibben MS Excel MVP

On Fri, 1 Jun 2007 03:55:00 -0700, SB wrote:

Of course I can move with mouse :) but how can I move sheets with using
keyboard only?

"Rick Rothstein (MVP - VB)" wrote:

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 the tab for the sheet that you want with your mouse? <g

Rick