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

Ctrl+Av.Pag

Regards,
Emece.-

"soconfused" wrote:

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

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

soconfused wrote:

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

--

Dave Peterson

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


"soconfused" wrote:

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

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


Gord Dibben MS Excel MVP



On Tue, 3 Feb 2009 09:54:01 -0800, Gary Brown
wrote:

Ctrl-F6
Ctrl-Shift-F6

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 different
sheets of the same workbook.


Gord Dibben MS Excel MVP

Previous Posts In This Thread:

On Tuesday, February 03, 2009 10:33 AM
soconfuse wrote:

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

On Tuesday, February 03, 2009 10:41 AM
Emec wrote:

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

Regards,
Emece.-

"soconfused" wrote:

On Tuesday, February 03, 2009 11:01 AM
Dave Peterson wrote:

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 the
activeworkbook.

soconfused wrote:

--

Dave Peterson

On Tuesday, February 03, 2009 12:54 PM
gary.brown.deletethispar wrote:

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


"soconfused" wrote:

On Tuesday, February 03, 2009 8:11 PM
Gord Dibben wrote:

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 different
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/tutorials...m-xml-web.aspx

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

On Wed, 02 Dec 2009 14:31:53 -0800, Steve B. wrote:

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 different
sheets of the same workbook.


Gord Dibben MS Excel MVP

Previous Posts In This Thread:

On Tuesday, February 03, 2009 10:33 AM
soconfuse wrote:

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

On Tuesday, February 03, 2009 10:41 AM
Emec wrote:

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

Regards,
Emece.-

"soconfused" wrote:

On Tuesday, February 03, 2009 11:01 AM
Dave Peterson wrote:

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 the
activeworkbook.

soconfused wrote:

--

Dave Peterson

On Tuesday, February 03, 2009 12:54 PM
gary.brown.deletethispar wrote:

Ctrl-F6Ctrl-Shift-F6-- Hope this helps.
Ctrl-F6
Ctrl-Shift-F6