Prev: Issue with pivot table
Next: kopirovanie bez zvysovania hodnoty
From: nils on 16 Apr 2010 04:55
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.
From: Roger Govier on 16 Apr 2010 05:02
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.
From: Ms-Exl-Learner on 16 Apr 2010 07:10
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.
From: Shailesh Shah on 16 Apr 2010 09:57

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



"nils" <nils(a)discussions.microsoft.com> wrote in message
news:887B08DD-F25E-4890-9C5B-6BC1885A5687(a)microsoft.com...
>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.


From: Gord Dibben on 16 Apr 2010 19:12
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/microsoft.public.excel.worksheet.functions/browse_frm/thread/935f5e174087f636/02c19464f875bd25?lnk=st&q=&rnum=1#02c19464f875bd25



Gord Dibben MS Excel MVP

On Fri, 16 Apr 2010 01:55:01 -0700, nils <nils(a)discussions.microsoft.com>
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.

 | 
Pages: 1
Prev: Issue with pivot table
Next: kopirovanie bez zvysovania hodnoty