Toggling between multiple notebook windows

[Jim]

I have been a user of QuattroPro for ten years, and I am
just now trying to convert everything over to Excel.

In QPW, when I have multiple notebooks (files) open at
the same time, each notebook's name is shown as a button
at the bottom of the screen in the status bar. (The files
are also listed under the Window drop down menu at the
top.)

This makes it really easy to toggle from one file to the
next by clicking on the button with the mouse.

Can this be done in Excel also?? The only thing I have
found so far is the Window drop down menu, and the file
names in the taskbar, but both of these are not as handy
as having the files shown in the status bar, or something
similar.

I am using Excel 2000 (9.0)

 

[David McRitchie]

Hi Jim,
You can use Ctrl+PageUp or Ctrl+PageDown to move to
the previous or to the next worksheet.

You can select from a list of worksheets by right-clicking on
any of the worksheet navigation arrows to the left of the
worksheet tabs. Such lists work a lot nicer if the sheets are
sorted alphabetically (with a macro).
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortallsheets

More on Navigation to a Sheetname (#MoreSheets) starting in
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets

 

[Guest]

Hi Dave:

Thanks for the response, however I may not have made my
question clear enough in the original post.

To jump between worksheets in one workbook, the
Ctrl+PageUp (or Down) keys work great. (This also works
in Quattro.)

My question though, is jumping between different
workbooks (or files) that I have open simultaneously. It
seems like a lot of steps to click on the Window drop
down menu, then click on the workbook, etc. In Quattro,
the names of all open workbooks are displayed along the
bottom of the screen in the status bar. This allows you
to put the cursor over the workbook desired, click once,
and you're there.

I hope this is a little clearer.

Thanks for your help, and I certainly appreciate any
assistance you can give me.

-----Original Message-----
Hi Jim,
You can use Ctrl+PageUp or Ctrl+PageDown to move to
the previous or to the next worksheet.

You can select from a list of worksheets by right- clicking on
any of the worksheet navigation arrows to the left of the
worksheet tabs. Such lists work a lot nicer if the sheets are
sorted alphabetically (with a macro).
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortall
sheets

More on Navigation to a Sheetname (#MoreSheets) starting in
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim" <[email protected]> wrote in

message news:[email protected]...

 

[Anders S]

Ctrl+Tab cycles workbooks.

HTH
Anders Silven

Hi Dave:

Thanks for the response, however I may not have made my
question clear enough in the original post.

To jump between worksheets in one workbook, the
Ctrl+PageUp (or Down) keys work great. (This also works
in Quattro.)

My question though, is jumping between different
workbooks (or files) that I have open simultaneously. It
seems like a lot of steps to click on the Window drop
down menu, then click on the workbook, etc. In Quattro,
the names of all open workbooks are displayed along the
bottom of the screen in the status bar. This allows you
to put the cursor over the workbook desired, click once,
and you're there.

I hope this is a little clearer.

Thanks for your help, and I certainly appreciate any
assistance you can give me.

-----Original Message-----
Hi Jim,
You can use Ctrl+PageUp or Ctrl+PageDown to move to
the previous or to the next worksheet.

You can select from a list of worksheets by right- clicking on
any of the worksheet navigation arrows to the left of the
worksheet tabs. Such lists work a lot nicer if the sheets are
sorted alphabetically (with a macro).
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortall
sheets

More on Navigation to a Sheetname (#MoreSheets) starting in
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim" <[email protected]> wrote in

message news:[email protected]...

.

 

[Gord Dibben]

Jim

Excel 2000 and newer have a Tools>Options>View "windows in taskbar" feature.

Checkmark it to get file tabs on the Taskbar.

Gord Dibben Excel MVP

Hi Dave:

Thanks for the response, however I may not have made my
question clear enough in the original post.

To jump between worksheets in one workbook, the
Ctrl+PageUp (or Down) keys work great. (This also works
in Quattro.)

My question though, is jumping between different
workbooks (or files) that I have open simultaneously. It
seems like a lot of steps to click on the Window drop
down menu, then click on the workbook, etc. In Quattro,
the names of all open workbooks are displayed along the
bottom of the screen in the status bar. This allows you
to put the cursor over the workbook desired, click once,
and you're there.

I hope this is a little clearer.

Thanks for your help, and I certainly appreciate any
assistance you can give me.

-----Original Message-----
Hi Jim,
You can use Ctrl+PageUp or Ctrl+PageDown to move to
the previous or to the next worksheet.

You can select from a list of worksheets by right- clicking on
any of the worksheet navigation arrows to the left of the
worksheet tabs. Such lists work a lot nicer if the sheets are
sorted alphabetically (with a macro).
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm#sortall
sheets

More on Navigation to a Sheetname (#MoreSheets) starting in
http://www.mvps.org/dmcritchie/excel/sheets.htm#moresheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jim" <[email protected]> wrote in

message news:[email protected]...

.

 

[SidBord]

If I understand you correctly, then each workbook should be
shown as a tab in the task bar. Switch between them by
clicking on the one you want. At least that was true
BEFORE Excel 2003. Now all similar tasks are gathered
together and are listed on a popup menu from the task bar.