View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default 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.