Minor Excel Problem

General Zod · Post by **General Zod** » 2006-10-13 05:46pm

This might be obvious to some people, but I rarely use Excel for anything except work, and most of what I do is fairly obvious. Since I've got no frakking clue which menu it would be under, I've got something that's driving me nuts I'd like some help getting changed.

I'm running Windows XP on the laptop with, afaik, the newest version of Excel. Whenever I have multiple spreadsheets open however, I can't separate the individual spreadsheets on the screen so they're overlapping. Instead it's as though they're tabbed rather than windowed. Unfortunately I've got no clue where to go to change this setting and I'm not really sure what to look for. So, any help would be cool.

SeeingRed · Post by **SeeingRed** » 2006-10-13 06:40pm

You can click the middle title bar button (the one that looks like two windows, one over the other) with Excel open. That will put that spreadsheet into its own mini-window inside the Excel window. You should also be able to see the other spreadsheets you have open lined up along the bottom of the main excel window, and can arrange them as you desire.

Chardok · Post by **Chardok** » 2006-10-13 11:13pm

SeeingRed wrote:You can click the middle title bar button (the one that looks like two windows, one over the other) with Excel open. That will put that spreadsheet into its own mini-window inside the Excel window. You should also be able to see the other spreadsheets you have open lined up along the bottom of the main excel window, and can arrange them as you desire.

Yeah, but only if they are *not* in the same workbook, I think...

Zed Snardbody · Post by **Zed Snardbody** » 2006-10-14 02:34am

Ok, let me see if I understand your problem correctly. You have multiple excel files open, and you want them in sperate windows on your screen? Instead, its only showing you one at a time, correct?

I'm going to assume thats your problem for the moment,

To correct this, go to Window, Arrange, Cascade, This will show you all the open workbooks in one excel "space". Ctrl+Tab will let you cycle through them.

I think this is what you wanted right? I'm sorry, I'm tired and what you're saying just isn't clicking with me at the moment.

General Zod · Post by **General Zod** » 2006-10-15 04:21pm

Zed Snardbody wrote:Ok, let me see if I understand your problem correctly. You have multiple excel files open, and you want them in sperate windows on your screen? Instead, its only showing you one at a time, correct?

I'm going to assume thats your problem for the moment,

To correct this, go to Window, Arrange, Cascade, This will show you all the open workbooks in one excel "space". Ctrl+Tab will let you cycle through them.

I think this is what you wanted right? I'm sorry, I'm tired and what you're saying just isn't clicking with me at the moment.

Almost forgot I put this topic up. And not exactly. I'm not needing to cycle through them in the same excel space, I'm wanting each spreadsheet set up as its own separate window, so I can view them side by side on one monitor. I can do the Ctrl + Tab thing, but that doesn't let me compare them side by side except within the same Excel space. Sorry for not being clear enough.