Switching between sheets in same workbook (Like Alt + Tab & Choose

[nils]

I want to swich between multiple sheets of active excel workbook with some
keyborad shortcuts.
We have Ctrl + Page Up/Page Down function to activate the desired sheet but
what i want is that it should give one pop-up showing all the sheet's name
and then i can choose any of them by using tab. Just like Alt + Tab to switch
beween the active programs of Windows.

 

[Roger Govier]

hi Nils

You can just right click on the rightmost arrow before first tab, and
that will give you a list of all sheets in the workbook to choose from.

 

[Ms-Exl-Learner]

Assume that you are in sheet1 and you would like to go to sheet3 press
Cntrl+G which will open goto dialog box and in Reference type Sheet3!A1 and
hit enter. Now the Active sheet will be sheet3. Like that In Goto Reference
type your sheet name with cell reference to move quickly between the sheets.

 

[Shailesh Shah]

Besides you may try to use "workbook navigation" Excel addins from below
site. It has many options to swich from one sheet to other sheet.


http://shahshaileshs.web.officelive.com/Addins.aspx


Regards,
Shailesh Shah
http://shahshaileshs.web.officelive.com/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://shahshaileshs.web.officelive.com/MenuAddins.aspx

Free Exshail Classic Menu for Excel-2007
http://shahshaileshs.web.officelive.com/Exshail_Classic_Menu.aspx

 

[Gord Dibben]

How about a sheet navigation toolbar from Dave Peterson?

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I like best, but that's me<g>

See this google search result. All one line for the URL

http://groups.google.com/group/micr...464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25



Gord Dibben MS Excel MVP