Can I toggle between sheets in a workbook without having to click?

[soconfused]

Can I toggle between sheets in a workbook without having to click them. I'm
referring to the "Alt Tab" I can do to switch applications. I was wondering
if there was anything like that for a workbook.

Thanks in anticipation.

 

[Emece]

Ctrl+Av.Pag

Regards,
Emece.-

 

[Dave Peterson]

You can use ctrl-pgup and ctrl-pgdn to cycle through the sheets of the
activeworkbook.

 

[Gary Brown]

Ctrl-F6
Ctrl-Shift-F6

 

[Gord Dibben]

This works if user has two workbooks open or if two windows with different
sheets of the same workbook.


Gord Dibben MS Excel MVP

 

[Steve B.]

Here is my solution.

View Tab - Window - New Window

That will create a new window of the same file. Choose the sheet you want to switch and then use the Alt Tab as usual.

In excel 03 it is under window tab.

Hope this will be helpfull.



Gord Dibben wrote:

This works if user has two workbooks open or if two windows with
03-Feb-09

This works if user has two workbooks open or if two windows with differen
sheets of the same workbook

Gord Dibben MS Excel MVP

Previous Posts In This Thread:

Can I toggle between sheets in a workbook without having to click?
Can I toggle between sheets in a workbook without having to click them. I'm
referring to the "Alt Tab" I can do to switch applications. I was wondering
if there was anything like that for a workbook

Thanks in anticipation
--
DMM

RE: Can I toggle between sheets in a workbook without having to click?
Ctrl+Av.Pa

Regards
Emece.

:

You can use ctrl-pgup and ctrl-pgdn to cycle through the sheets of
You can use ctrl-pgup and ctrl-pgdn to cycle through the sheets of th
activeworkbook

soconfused wrote

-

Dave Peterson

Ctrl-F6Ctrl-Shift-F6-- Hope this helps.
Ctrl-F
Ctrl-Shift-F
-
Hope this helps
If it does, please click the Yes button
Thanks in advance for your feedback
Gary Brow

:

This works if user has two workbooks open or if two windows with
This works if user has two workbooks open or if two windows with differen
sheets of the same workbook

Gord Dibben MS Excel MVP


Submitted via EggHeadCafe - Software Developer Portal of Choice
Creating A Custom XML Web Control
http://www.eggheadcafe.com/tutorial...6-3399ea946e75/creating-a-custom-xml-web.aspx

 

[Gord Dibben]

I do believe you have your Alt and Ctrl keys mixed up.

Ctrl + Tab or Ctrl + F6 will switch windows within Excel.

Alt + Tab will cycle through all open applications.


Gord Dibben MS Excel MVP