Is there a shortcut to quickly alternate between worksheets that aren't next
to each other? (e.g. similar to using ALT + TAB to alternate between windows?)

Thanks.

Adrian,

If you do Window New Window, it will open a second window for the same
file. Then you can set each window to a different sheet in the file. If
you have the "Windows in Taskbar" (Tools Options... View tab Show
section (first section)) setting turned on, then you can user the [Alt] +
[Tab] to switch between the 2.

Keep in mind, these instructions are for XL 2002 & 2003. Don't know 2007
yet. Search Help for "Windows in Taskbar".

HTH,

Conan




"Adrian" wrote in message
...
Is there a shortcut to quickly alternate between worksheets that aren't
next
to each other? (e.g. similar to using ALT + TAB to alternate between
windows?)

Thanks.

hi
you can right click on the sheet navigator in the lower left corner of the
sheet. you will get a pop up showing all your sheets. clck one to go to it.
if you have more than 15? sheets, there will be a "more sheets" options.
click that and you get a scrollable "text box?" with all of your sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change A
LOT!

Regards
FSt1

"Adrian" wrote:

Is there a shortcut to quickly alternate between worksheets that aren't next
to each other? (e.g. similar to using ALT + TAB to alternate between windows?)

Thanks.

On 6 Dec, 17:14, FSt1 wrote:
hi
you can right click on the sheet navigator in the lower left corner of the
sheet. you will get a pop up showing all your sheets. clck one to go to it.
if you have more than 15? sheets, there will be a "more sheets" options.
click that and you get a scrollable "text box?" with all of your sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change A
LOT!

Regards
FSt1

"Adrian" wrote:
Is there a shortcut to quickly alternate between worksheets that aren't next
to each other? (e.g. similar to using ALT + TAB to alternate between windows?)

Thanks.

FSt1....Wow only been mucking around with xl for 5 years never noticed
that

matthew

Awesome - thanks Conan!

"Conan Kelly" wrote:

Adrian,

If you do Window New Window, it will open a second window for the same
file. Then you can set each window to a different sheet in the file. If
you have the "Windows in Taskbar" (Tools Options... View tab Show
section (first section)) setting turned on, then you can user the [Alt] +
[Tab] to switch between the 2.

Keep in mind, these instructions are for XL 2002 & 2003. Don't know 2007
yet. Search Help for "Windows in Taskbar".

HTH,

Conan




"Adrian" wrote in message
...
Is there a shortcut to quickly alternate between worksheets that aren't
next
to each other? (e.g. similar to using ALT + TAB to alternate between
windows?)

Thanks.

I can't seem to find the navigator. What does the icon look like?

Thanks

"FSt1" wrote:

hi
you can right click on the sheet navigator in the lower left corner of the
sheet. you will get a pop up showing all your sheets. clck one to go to it.
if you have more than 15? sheets, there will be a "more sheets" options.
click that and you get a scrollable "text box?" with all of your sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change A
LOT!

Regards
FSt1

"Adrian" wrote:

Is there a shortcut to quickly alternate between worksheets that aren't next
to each other? (e.g. similar to using ALT + TAB to alternate between windows?)

Thanks.

Adrian,

It is just to the left of the sheet tabs. There is 4 small buttons that
look kinda like previous track, play in reverse (if there was such a thing),
play, and next track on a CD/DVD player.

HTH,

Conan




"Adrian" wrote in message
...
I can't seem to find the navigator. What does the icon look like?

Thanks

"FSt1" wrote:

hi
you can right click on the sheet navigator in the lower left corner of
the
sheet. you will get a pop up showing all your sheets. clck one to go to
it.
if you have more than 15? sheets, there will be a "more sheets" options.
click that and you get a scrollable "text box?" with all of your sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change
A
LOT!

Regards
FSt1

"Adrian" wrote:

Is there a shortcut to quickly alternate between worksheets that aren't
next
to each other? (e.g. similar to using ALT + TAB to alternate between
windows?)

Thanks.

aha - thanks!

BTW, what does HTH mean?

"Conan Kelly" wrote:

Adrian,

It is just to the left of the sheet tabs. There is 4 small buttons that
look kinda like previous track, play in reverse (if there was such a thing),
play, and next track on a CD/DVD player.

HTH,

Conan




"Adrian" wrote in message
...
I can't seem to find the navigator. What does the icon look like?

Thanks

"FSt1" wrote:

hi
you can right click on the sheet navigator in the lower left corner of
the
sheet. you will get a pop up showing all your sheets. clck one to go to
it.
if you have more than 15? sheets, there will be a "more sheets" options.
click that and you get a scrollable "text box?" with all of your sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change
A
LOT!

Regards
FSt1

"Adrian" wrote:

Is there a shortcut to quickly alternate between worksheets that aren't
next
to each other? (e.g. similar to using ALT + TAB to alternate between
windows?)

Thanks.

Adrian,

HTH = Hope this helps.

When ever I come across acronyms I don't know, I go to acronymfinder.com to
look them up (hopefully I spelled "acronym" correctly).

HTH,

Conan




"Adrian" wrote in message
...
aha - thanks!

BTW, what does HTH mean?

"Conan Kelly" wrote:

Adrian,

It is just to the left of the sheet tabs. There is 4 small buttons that
look kinda like previous track, play in reverse (if there was such a
thing),
play, and next track on a CD/DVD player.

HTH,

Conan




"Adrian" wrote in message
...
I can't seem to find the navigator. What does the icon look like?

Thanks

"FSt1" wrote:

hi
you can right click on the sheet navigator in the lower left corner of
the
sheet. you will get a pop up showing all your sheets. clck one to go
to
it.
if you have more than 15? sheets, there will be a "more sheets"
options.
click that and you get a scrollable "text box?" with all of your
sheets.
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have
change
A
LOT!

Regards
FSt1

"Adrian" wrote:

Is there a shortcut to quickly alternate between worksheets that
aren't
next
to each other? (e.g. similar to using ALT + TAB to alternate between
windows?)

Thanks.

Hi FSt1,

I hope you're still watching this thread. What i found in 2007 is that this
works ~until~ you put protection on the worksheet, after that, Excel ignores
the control key and simply pages up or down.

Why oh why did they muck this up. I used this key combos ALL the time.

CmdrSlam

"FSt1" wrote:
<snip
you can also do the ctlr+page up and ctrl+ page down like alt+tab to
navigate through the sheets.
may not apply to 2007. still stuck on xp here and i hear they have change A
LOT!

Regards
FSt1