In Excel I wanted to view two worksheets at once. Checked "windows of active
workbook". Worked fine but now all my worksheets open this way in a floating
window. How do I cancel this feature?

When you open one of the workbooks that has multiple windows, you can close one
of the windows this way.

Select the window to close
hit ctrl-w
save that workbook (or it'll open that way the next time, too.)

To resize the window, just maximize that window. Save the workbook.

Excel likes to help -- if you have worksheet windows that are less than
maximized windows, then excel will open the next workbook in a window.

If you always use maximized windows, then excel will remember that, too.

Wayne Lee wrote:

In Excel I wanted to view two worksheets at once. Checked "windows of active
workbook". Worked fine but now all my worksheets open this way in a floating
window. How do I cancel this feature?

--

Dave Peterson

Dave, Thanks! I was going crazy lasy night trying to fix this.

"Wayne Lee" wrote:

In Excel I wanted to view two worksheets at once. Checked "windows of active
workbook". Worked fine but now all my worksheets open this way in a floating
window. How do I cancel this feature?

Keep your eyes open for a title bar that contains the workbookname.xls:#
(like book1.xls:2).

If you see that colon-number, your workbook has multiple windows open. (Just
resizing the windows can mask this problem/feature.

Wayne Lee wrote:

Dave, Thanks! I was going crazy lasy night trying to fix this.

"Wayne Lee" wrote:

In Excel I wanted to view two worksheets at once. Checked "windows of active
workbook". Worked fine but now all my worksheets open this way in a floating
window. How do I cancel this feature?

--

Dave Peterson