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


S

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.
 
Ad

Advertisements

D

Dave Peterson

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

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
 
S

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top