Thread: Go to Sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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