ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   XL 2007 - Multiple windows for spreadsheets (SDI) (https://www.excelbanter.com/excel-discussion-misc-queries/123794-xl-2007-multiple-windows-spreadsheets-sdi.html)

MF

XL 2007 - Multiple windows for spreadsheets (SDI)
 
In Excel 2007, how can we view separate spreadsheets in separate windows?
This has *got* to be simple, but darn if I can find a setting for it...

A nice example of what we can to do is to tile multiple spreadsheets or view
two side-by-side (NOT using "View Side By Side" in the View ribbon)...

Thanks in advance for any tips!

-=- mf

Bob Phillips

XL 2007 - Multiple windows for spreadsheets (SDI)
 
Click the Office button, then the 'Excel Options' button., select Advanced
from the left pane, then in the Display section, check the Show all windows
in the Taskbar.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MF" wrote in message
...
In Excel 2007, how can we view separate spreadsheets in separate windows?
This has *got* to be simple, but darn if I can find a setting for it...

A nice example of what we can to do is to tile multiple spreadsheets or
view
two side-by-side (NOT using "View Side By Side" in the View ribbon)...

Thanks in advance for any tips!

-=- mf




MF

XL 2007 - Multiple windows for spreadsheets (SDI)
 
I do have that checked, but i can't seem to open two different spreadsheets
and manipulate their windows independently... (i can select them individually
from the taskbar, but when i select one, the other disappears...)

Is this PEBCAK?

Or is this how Excel 07 works?

Thanks for the suggestion!

-=- mf

"Bob Phillips" wrote:

Click the Office button, then the 'Excel Options' button., select Advanced
from the left pane, then in the Display section, check the Show all windows
in the Taskbar.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MF" wrote in message
...
In Excel 2007, how can we view separate spreadsheets in separate windows?
This has *got* to be simple, but darn if I can find a setting for it...

A nice example of what we can to do is to tile multiple spreadsheets or
view
two side-by-side (NOT using "View Side By Side" in the View ribbon)...

Thanks in advance for any tips!

-=- mf





MF

XL 2007 - Multiple windows for spreadsheets (SDI)
 
OK, I call semi-PEBCAK on myself; one needs to simply launch another
instance of Excel to be able to manage and manipulate separate spreadsheet
windows...

Guess I'm always trying to do things the hard way! :-)

"MF" wrote:

I do have that checked, but i can't seem to open two different spreadsheets
and manipulate their windows independently... (i can select them individually
from the taskbar, but when i select one, the other disappears...)

Is this PEBCAK?

Or is this how Excel 07 works?

Thanks for the suggestion!

-=- mf

"Bob Phillips" wrote:

Click the Office button, then the 'Excel Options' button., select Advanced
from the left pane, then in the Display section, check the Show all windows
in the Taskbar.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MF" wrote in message
...
In Excel 2007, how can we view separate spreadsheets in separate windows?
This has *got* to be simple, but darn if I can find a setting for it...

A nice example of what we can to do is to tile multiple spreadsheets or
view
two side-by-side (NOT using "View Side By Side" in the View ribbon)...

Thanks in advance for any tips!

-=- mf





Bob Phillips

XL 2007 - Multiple windows for spreadsheets (SDI)
 
Have you tried View Side By Side on the View tab?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MF" wrote in message
...
OK, I call semi-PEBCAK on myself; one needs to simply launch another
instance of Excel to be able to manage and manipulate separate spreadsheet
windows...

Guess I'm always trying to do things the hard way! :-)

"MF" wrote:

I do have that checked, but i can't seem to open two different
spreadsheets
and manipulate their windows independently... (i can select them
individually
from the taskbar, but when i select one, the other disappears...)

Is this PEBCAK?

Or is this how Excel 07 works?

Thanks for the suggestion!

-=- mf

"Bob Phillips" wrote:

Click the Office button, then the 'Excel Options' button., select
Advanced
from the left pane, then in the Display section, check the Show all
windows
in the Taskbar.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"MF" wrote in message
...
In Excel 2007, how can we view separate spreadsheets in separate
windows?
This has *got* to be simple, but darn if I can find a setting for
it...

A nice example of what we can to do is to tile multiple spreadsheets
or
view
two side-by-side (NOT using "View Side By Side" in the View
ribbon)...

Thanks in advance for any tips!

-=- mf






Jon Peltier

XL 2007 - Multiple windows for spreadsheets (SDI)
 
View tab of the ribbon, Window group, Arrange All.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"MF" wrote in message
...
In Excel 2007, how can we view separate spreadsheets in separate windows?
This has *got* to be simple, but darn if I can find a setting for it...

A nice example of what we can to do is to tile multiple spreadsheets or
view
two side-by-side (NOT using "View Side By Side" in the View ribbon)...

Thanks in advance for any tips!

-=- mf





All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com