Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to sheet
Dear All,
In my excel file there are 20 to 30 sheets with the sheet names as Sheet1, sheet2, and so on. Is there is any way to go to sheet directly i.e if I want to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to sheet
Hi,
Right click the fast forward/rewind control (To the left of the first workshheet tab) and click the sheet name you want to go to. Mike "Vital_ar" wrote: Dear All, In my excel file there are 20 to 30 sheets with the sheet names as Sheet1, sheet2, and so on. Is there is any way to go to sheet directly i.e if I want to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to sheet
If you click on one of the sheet navigation arrows at lower left you will
get a list of 15 sheets and "more" You can build a Sheet Navigation Toolbar as per Dave Peterson's code on Debra Dalgleish's site. Sorts as well as navigates. http://www.contextures.on.ca/xlToolbar01.html Or see this google search thread for the BrowseSheets macro from Bob Phillips. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Tue, 27 Oct 2009 08:12:06 -0700, Vital_ar wrote: Dear All, In my excel file there are 20 to 30 sheets with the sheet names as Sheet1, sheet2, and so on. Is there is any way to go to sheet directly i.e if I want to go to sheet28 I have to go there by using mouse or Ctrl+Pg Dn Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
"='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |