Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Erin
 
Posts: n/a
Default 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
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

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

  #3   Report Post  
JS
 
Posts: n/a
Default

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

  #4   Report Post  
Duke Carey
 
Posts: n/a
Default

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get existing Excel workbooks to open in separate windows Christy99 Excel Worksheet Functions 1 March 22nd 05 12:26 AM
open multiple workbooks at startup Ron Z Excel Discussion (Misc queries) 2 January 21st 05 03:21 AM
Can you update links between workbooks without them both open? Nicolle K. Excel Discussion (Misc queries) 1 January 7th 05 07:39 PM
Excel does not display workbooks open PeiMei Setting up and Configuration of Excel 0 December 9th 04 04:13 PM
Workbooks...I'll try this again... Markster Excel Discussion (Misc queries) 10 December 7th 04 10:12 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"