multiple windows

[drofnats]

i'm not sure if this has to do with the settings in
Windows 98 or Office 97, but when i have multiple excel
(or any ms office) files open at the same time, i will
have only the 1 active excel window being displayed on my
taskbar and i have to go to "Window" in the excel menu bar
to switch between files. I've tried unsuccessfully to
find the settings where it will allow multiple files to be
displayed on my windows taskbar. can anyone help? Thanks

Stan

 

[Trevor Shuttleworth]

I think this an Office 2000 (+) option.

Tools | Options | View tab | Show Windows in Taskbar

Regards

Trevor

 

[Rollin_Again]

*i'm not sure if this has to do with the settings in
Windows 98 or Office 97, but when i have multiple excel
(or any ms office) files open at the same time, i will
have only the 1 active excel window being displayed on my
taskbar and i have to go to "Window" in the excel menu bar
to switch between files. I've tried unsuccessfully to
find the settings where it will allow multiple files to be
displayed on my windows taskbar. can anyone help? Thanks

Stan *

I don't know if it's available in the version of Excel you are usin
but there is a setting in the newer versions. Try clicking TOOLS ---
OPTIONS and select the "VIEW" tab. There should be a checkbox tha
says "Windows in Taskbar." Check this box and you should have
seperate window in a minimized state in your taskbar.


Rolli

 

[Tess]

Hi "drofnats"
I have to do it often with Word & Excel 97. It's a little
tedious, but it works.
Open Excel spreadsheet & click applic "restore" button; it
becomes "half screen". Open Word document & click
applic "restore" button; it too becomes half screen. One
window may cover the other. Move the top one out of the
way above or below. To open another doc or spreadsheet in
an application, "file, Open" in your active application.
You can resize the resulting combined docs or sheets in
the active application. Problem is, you won't have much
room to work. You can resize either applic window if you
need more space to operate. Be sure you maximize the
application window(s) before you save & close.
Tess

 

[Dave Peterson]

But you could use some keyboard shortcuts to travel between workbooks:

Ctrl-tab (and ctrl-shift-tab)
or
Ctrl-F6 (and ctrl-shift-F6)

(ctrl-pageup/ctrl-page down moves between worksheets)

 

[drofnats]

thanks everybody for their responses. i guess i'm just
spoiled on my home computer with office 2000. they got me
on office 97 here at work.

 

[Guest]

Hi Dave
Thanks for that control-tab shortcut. I'd forgotten about that one

Regards
Mark Graesse
(e-mail address removed)
Boston M

----- Dave Peterson wrote: ----

But you could use some keyboard shortcuts to travel between workbooks

Ctrl-tab (and ctrl-shift-tab
o
Ctrl-F6 (and ctrl-shift-F6

(ctrl-pageup/ctrl-page down moves between worksheets

drofnats wrote

 

[Jay]

i'm not sure if this has to do with the settings in
Windows 98 or Office 97, but when i have multiple excel
(or any ms office) files open at the same time, i will
have only the 1 active excel window being displayed on my
taskbar and i have to go to "Window" in the excel menu bar
to switch between files. I've tried unsuccessfully to
find the settings where it will allow multiple files to be
displayed on my windows taskbar. can anyone help? Thanks

I'm aware of two different ways to get different taskbar items for
different Excel files.

#1. From the Windows "Start" menu, use the cascaded menu to open Excel.
Once Excel is running, use "File >> Open" to open an Excel file. Repeat the
steps for each file.

#2. Point to an Excel file on the desktop or in a folder. With the right
mouse button, click "Send To >> Excel". Repeat the steps for each file.

For way #2, you might not see "Excel" in the "Send To" menu at first. To
add it
there, put a shortcut to the Excel program into the folder
C:\Windows\SendTo\

By the way, if you have two files of the same name in different folders,
this allows you to have both open at the same time.