ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Unwanted instance od a window (https://www.excelbanter.com/excel-discussion-misc-queries/177034-unwanted-instance-od-window.html)

donbowyer

Unwanted instance od a window
 
MS Office 2003 on Win XP
I have a simple WorkBook with several (spread)sheets; no macros.
The file is called MyFile.xls.
When it's open, and I click Window on the menu bar, I'm given a choice of 2
windows shown as:-
1 MyFile.xls:1 and 2 MyFile.xls:2
They each show identical windows when selected.
I didn't (knowingly) create 2 windows.
How do I remove the redundant one?

donwb

Dave Peterson

Unwanted instance od a window
 
It's actually two different windows or views into the same workbook.

Select the window you don't want and hit ctrl-w.

Then save the workbook--or you'll be doing it again.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

donbowyer wrote:

MS Office 2003 on Win XP
I have a simple WorkBook with several (spread)sheets; no macros.
The file is called MyFile.xls.
When it's open, and I click Window on the menu bar, I'm given a choice of 2
windows shown as:-
1 MyFile.xls:1 and 2 MyFile.xls:2
They each show identical windows when selected.
I didn't (knowingly) create 2 windows.
How do I remove the redundant one?

donwb


--

Dave Peterson

donbowyer

Unwanted instance od a window
 
Many thanks dave
--
donwb


"Dave Peterson" wrote:

It's actually two different windows or views into the same workbook.

Select the window you don't want and hit ctrl-w.

Then save the workbook--or you'll be doing it again.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

donbowyer wrote:

MS Office 2003 on Win XP
I have a simple WorkBook with several (spread)sheets; no macros.
The file is called MyFile.xls.
When it's open, and I click Window on the menu bar, I'm given a choice of 2
windows shown as:-
1 MyFile.xls:1 and 2 MyFile.xls:2
They each show identical windows when selected.
I didn't (knowingly) create 2 windows.
How do I remove the redundant one?

donwb


--

Dave Peterson



All times are GMT +1. The time now is 08:53 PM.

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