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