ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   File:1 and File:2 -- Double Files when Opening One File (https://www.excelbanter.com/excel-discussion-misc-queries/127611-file-1-file-2-double-files-when-opening-one-file.html)

dallin

File:1 and File:2 -- Double Files when Opening One File
 
I open a file called file.xls and it auto opens two versions calling one
File:1 and File:2. I don't understand what option has been selected or why
Excel does this? Please explain.

Dave Peterson

File:1 and File:2 -- Double Files when Opening One File
 
You actually have two windows open to the same workbook.

Select the one you don't want anymore and hit ctrl-w

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

This can be a useful feature if you want to see different parts of the workbook
at the same time.

Window|New window
(to create that second window)

then
Window|Arrange|Horizontal (or the way you like it)

dallin wrote:

I open a file called file.xls and it auto opens two versions calling one
File:1 and File:2. I don't understand what option has been selected or why
Excel does this? Please explain.


--

Dave Peterson


All times are GMT +1. The time now is 06:11 AM.

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