Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Sheets within a workbook | Excel Worksheet Functions | |||
Moving data between Excel sheets | Excel Discussion (Misc queries) | |||
Moving thru sheets in Excel | Excel Discussion (Misc queries) | |||
Are there keyboard shortcuts for moving between sheets in Excel? | Excel Discussion (Misc queries) | |||
Moving through sheets | Excel Discussion (Misc queries) |