Is there a way to tab between open workbooks?
 

OK say if you have 3 or 5 open workbooks and you need to refer to all of them
at different periods of the day. Instead of min maxing the windows is there a
way to tab from one to the other? Like how the alt/tab function works...
Thanks,
Erin

Yes (sort of)

[Alt]+[W] will list open workbooks. The click the number of the one you
want to go to.

Regards,
Ron


"Erin" wrote:

OK say if you have 3 or 5 open workbooks and you need to refer to all of them
at different periods of the day. Instead of min maxing the windows is there a
way to tab from one to the other? Like how the alt/tab function works...
Thanks,
Erin

try ctrl+tab

"Erin" wrote:

OK say if you have 3 or 5 open workbooks and you need to refer to all of them
at different periods of the day. Instead of min maxing the windows is there a
way to tab from one to the other? Like how the alt/tab function works...
Thanks,
Erin

Use Ctrl-F6 & Ctrl-Shift F6

"JS" wrote:

try ctrl+tab

"Erin" wrote:

OK say if you have 3 or 5 open workbooks and you need to refer to all of them
at different periods of the day. Instead of min maxing the windows is there a
way to tab from one to the other? Like how the alt/tab function works...
Thanks,
Erin