Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to Sheet
Dear All,
It will be easy if there is any Key Board short Cut to go to a Specific Work Sheet in a Work Book. For example i am working in a work book which contains 92 Sheets (in some times it will cross 122+ also). So every time I use mose or Ctrl+PG Dn or Pg Up to go to that sheet. So if there is any option like go to sheet such that i can directly go that specific sheet. (I am remebering all the work sheet names in that work book so i can direclty go to that sheet if any option is like that) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to Sheet
2 options:
a) right click on one of the "go to end" sheet navigation arrows and use that to pick the sheet you want b) Press Ctl+G to bring up the goto dialogue. Simply type the name of your sheet and add a dummy cell reference like: 'My Sheet'!A1 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Vital_ar" wrote: Dear All, It will be easy if there is any Key Board short Cut to go to a Specific Work Sheet in a Work Book. For example i am working in a work book which contains 92 Sheets (in some times it will cross 122+ also). So every time I use mose or Ctrl+PG Dn or Pg Up to go to that sheet. So if there is any option like go to sheet such that i can directly go that specific sheet. (I am remebering all the work sheet names in that work book so i can direclty go to that sheet if any option is like that) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to Sheet
If you want a generic solution (good for any open workbook)...
http://contextures.com/xlToolbar01.html (From Debra Dalgleish's site.) It builds a toolbar that you can use with any workbook to navigate to any worksheet. There's a link on that site for an xl2007 version for the ribbon (from Ron de Bruin). If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) Vital_ar wrote: Dear All, It will be easy if there is any Key Board short Cut to go to a Specific Work Sheet in a Work Book. For example i am working in a work book which contains 92 Sheets (in some times it will cross 122+ also). So every time I use mose or Ctrl+PG Dn or Pg Up to go to that sheet. So if there is any option like go to sheet such that i can directly go that specific sheet. (I am remebering all the work sheet names in that work book so i can direclty go to that sheet if any option is like that) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
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) |