Software

Ask something
Discussion Locked

Excel Question

0 helpful
7 replies

by cwhitten

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
In Excel when you have a workbook open, you can go up to the Windows menu and select New window and it makes a new window of the same workbook. The only way I know how to get rid of this extra window is to hide it. Is there a way to remove this? Now, when I pull up Excel for the first time my default title bar reads personal instead of book 1. When I open up a new document it then goes back to book 1. How can I fix it back to default to book 1?

7 replies

by mslizny

The "New Window" command on the "Window" menu is used to view several sheets of the same workbook file at once. When you have clicked "New Window" you can then go to "Window" and choose "Arrange" (I would suggest the "tiled" option. You might alsowant to click the checkbox to arrange only the windows of the currently open workbook. When you do this each window of the workbook is shown, smaller than the 'maximize' size. Any window you close by clicking the 'X' in the top right corner is closed, all other open windows remain. Do this until only one window of the workbook is left. Choosing File, Close from the menu closes all open windows for the workbook.

by shanghai sam

I know you can tile the windows and then close them one by one, but when you close the file completely and then go back into the file and look under window all the duplicated windows are there. How can I make them stay closed except for the original window?
Also, when I open Excel now, the blank document(titel bar) reads Personal.xls in the title bar instead of Book 1. It did this after I made a duplicate using the window, new window. Is this a hidden macro somewhere?

by mslizny

Save the file after you have deleted the additional windows. When you re-open it the additional windows are no longer there.

The Personal workbook is usually the "Personal Macro Workbook," and it indicates that you have chosen to save a macro ina location where it can be used by any Excel file. Perhaps you have unexpectedly started the process of recording a macro, but Excel is treating the process as incomplete, as the macro recording or saving process has not been finished.

by shanghai sam

Ok, I created another duplicate window and I closed the duplicate window before I saved it. When I go back into the file it brings up the dialog box that ask me to disable macros, enables macros, etc....but the duplicate window is closed like you stated, but why is it asking me about the macros? I think it has something to do with the Personal.xls page opening up when I go into Excel and I don't know how to tell it not to open. I can't find anything under macros.

by kewharp

It's my understanding that the Personal.xls file always opens when you start Excel. The difference in your situation is that it is set up to show. Go to the Window menu and select Hide. That should hide it for the next time you open Excel.

The Personal.xls file is not related to you selecting Window/New Window. As far as doing Window/New Window, this just gets you another view of the same file you are in. If your file is named "MyWorksheet," then the first time you select New Window, the new window will have the name "MyWorksheet:1", the 2nd will have "MyWorksheet:2" etc.

by cwhitten

I finally got this problem taken care of and I'm back to normal. Thanks for the inputs.

This discussion is closed to new replies.