Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default When I open a document it automatically opens up in 2 windows.

I try to open up my worksheet in excel and it opens as two identical
worksheets. How did this happen and how do I get the second worksheet to
disapear?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default When I open a document it automatically opens up in 2 windows.

Do you see something like: Book1.xls:1 and Book1.xls:2 in the title bars?

If yes, then you haven't duplicated any worksheets. But you have opened a
second window into that same workbook.

If you want to close one, just click on it and hit ctrl-w

Remember to save the workbook before you close--else you'll be doing it again.

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

This can be caused by using:
Window|New window
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.

mojofaerie wrote:

I try to open up my worksheet in excel and it opens as two identical
worksheets. How did this happen and how do I get the second worksheet to
disapear?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When open document, want date to be current automatically. How? Rae Excel Discussion (Misc queries) 5 August 29th 07 03:34 PM
Outlook opens twice in two different windows Spidey Excel Discussion (Misc queries) 2 July 28th 07 03:16 PM
Opens bhind other windows or minimized Jmmac04 Excel Discussion (Misc queries) 0 April 17th 06 05:34 PM
Prevent open excel windows from automatically closing. Prevent Automatic Closing Excel Discussion (Misc queries) 1 April 10th 06 10:27 PM
Macro opens two windows banSHF Excel Discussion (Misc queries) 1 September 7th 05 02:14 AM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"