Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2004

Tip: Looking for answers? Try searching our database.

Toggling between multiple notebook windows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim - 28 Apr 2004 21:15 GMT
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 - 28 Apr 2004 21:27 GMT
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
---
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

> I have been a user of QuattroPro for ten years, and I am
> just now trying to convert everything over to Excel.
[quoted text clipped - 15 lines]
>
> I am using Excel 2000 (9.0)
- 28 Apr 2004 21:55 GMT
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,
[quoted text clipped - 6 lines]
>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,
[quoted text clipped - 23 lines]
>
>.
Anders S - 29 Apr 2004 00:06 GMT
Ctrl+Tab cycles workbooks.

HTH
Anders Silven
> Hi Dave:
>
[quoted text clipped - 76 lines]
> >
> >.
Gord Dibben - 29 Apr 2004 00:25 GMT
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

On Wed, 28 Apr 2004 13:55:30 -0700, <anonymous@discussions.microsoft.com>
wrote:

>Hi Dave:
>
[quoted text clipped - 76 lines]
>>
>>.
SidBord - 29 Apr 2004 20:07 GMT
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.
>-----Original Message-----
>I have been a user of QuattroPro for ten years, and I am
[quoted text clipped - 17 lines]
>I am using Excel 2000 (9.0)
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.