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


N

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.
 
Ad

Advertisements

R

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.
 
M

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.
 
S

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top