would like Seperate Excel Windows

[Jim Fisher]

It would be NICE to be able to open 2 Excel files in Different Windows, like
Word Documents.

It would Also be Nice to open PowerPoint files in different windows as well.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[ryguy7272]

Window > Arrange > Horizontal, Vertical, etc.

Window > Split


Hope that helps,
Ryan---

 

[David Biddulph]

Window/ New Window to open a new window, then open your second file from
that window.

 

[M-A]

Jim,

Hopefully the guys have answered your question, but I read your question as
being two completely independent windows.

Which version of excel are you using? If you have your first document open,
then click on the excel icon and a new, completely separate window will
appear. you then open your second spreadsheet using the Open command in the
file menu.

Ryan, David,
I hope you don't mind the addition. I'm using Office 2003 and both of these
solutions would actually be 'sharing' a window. I use those solutions when
I'm at my desktop, but when I'm using a smaller laptop screen (or using a
couple of spreadsheets and a word document) I quite like having independent
windows I can move, overlap and resize during the work.

It actually took me ages to come around to the 'new window' way of working
just because I wasn't used to it, but I'm getting there now
M-A

 

[Jim Fisher]

-Hi-

I'm using Office 2007.

In Word, if you open 2 documents, you get two seperate windows, each window
is independent of the other, each with its own ribbon.

In Excel or PowerPoint, if you open 2 Excel or PPT's files you Must work
within the boundaries of your Excel Window....the Excel file are not
independent. If you want 2 Excel Sheets side by side you have to "widen" the
"base" Excel Window to view both Excel file side-by-side. Having to use the
same ribbon for both Excel files slows my progress, as well as having to
Constantly having to Manually ADJUSTING each files position.

The same is true for PowerPoint. This is not constant behavior with Word.

-Jim

 

[Beege]

Hi, Jim

I'm using Excel 2002, and if I:

Tools/Options/View(tab)/Check "Windows in Taskbar"

I get separate windows for each workbook, but the tool bars are the same
for each.

Perhaps you need command-line shortcuts for each file (I'm not sure if
tool bars can be called up separately for each workbook. Need to
research that!)

Good luck with it

Beege

 

[M-A]

Hi Jim,

I was on a machine with 2003 yesterday, so my apologies for the delay.

I've just tried this on my 2007 machine and I see what you mean. I hadn't
noticed it before because I ALWAYS open my second spreadsheet in a separate
excel window so i do get the independence.

I'm going to go an vote for your comment now. I actually don't mind which
way it works, but I do think it should be consistent (and preferably
something the user can set in options to decide whether they want the same
window or different).

As you've mentioned that this is really slowing you down, I've double
checked and the previous suggestion does still work in 2007. It's only a
workaround but hopefully it will help while you wait for your suggestion to
be considered.
Open your first spreadsheet as normal.
Then to open the second spreadsheet click on your excel icon (on your
desktop, or start menu or wherever). This will open a second, independent
window and you can do 'file open' from there to open your second spreadsheet
independently. You now have two completely separate windows that can move
independently and each have their own ribbons.

M-A

 

[JNL]

Jim,

I too would like the solution for Excel to split windows like you can in
Word. Have you figured out how yet? I haven't been able to find a solution
yet.