undo window arrange in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I keep "Windows of active workbook check box" checked 1
2 excel workbooks open up from 1 file; named :1 and :2 - why? 1
Undo jumps between multiple open workbooks 4
"Undo" in Excel 2007 3
How do I look at two worksheets in one Excel workbook at same time 2
Excel 2007 Undo Feature With Multiple Workbooks Open 1
how do i open excel files in different worksheets? 1
Arrange Worksheets 1

Back
Top