If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Switching between sheets in same workbook (Like Alt + Tab & Choose
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. |
#2
|
|||
|
|||
Switching between sheets in same workbook (Like Alt + Tab & Choose
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. -- Regards Roger Govier nils wrote: 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. |
#3
|
|||
|
|||
Switching between sheets in same workbook (Like Alt + Tab & Choose
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. -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "nils" wrote: 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. |
#4
|
|||
|
|||
Switching between sheets in same workbook (Like Alt + Tab & Choose
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....ssic_Menu.aspx "nils" wrote in message ... 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. |
#5
|
|||
|
|||
Switching between sheets in same workbook (Like Alt + Tab & Choose
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 meg See this google search result. All one line for the URL http://groups.google.com/group/micro...c19464f875bd25 Gord Dibben MS Excel MVP On Fri, 16 Apr 2010 01:55:01 -0700, nils wrote: 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. |
Thread Tools | |
Display Modes | |
|
|