| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why did Excel create two identical worksheets?
I am using Excel 2003 - Version 5.1.2600 Service Pack 2 Build 2600.
When I open a particular file, Excel shows that two files are open. They are named the same but end with :1 and :2. Why did this occur and how can I delete one of these? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why did Excel create two identical worksheets?
You or someone else clicked WINDOW in the menu and selected NEW WINDOW. To
remove the extra window click the X close button on the right side of the menu bar to close the extra window and resave the file. (The close window is not the X in the red button on the title bar, which closes the app, but the one below it) -- Kevin Backmann "ajones1978" wrote: I am using Excel 2003 - Version 5.1.2600 Service Pack 2 Build 2600. When I open a particular file, Excel shows that two files are open. They are named the same but end with :1 and :2. Why did this occur and how can I delete one of these? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why did Excel create two identical worksheets?
They're actually two windows open to the same workbook.
It can be nice to see different worksheets or even different areas of the same worksheet in separate windows. You can close the window you don't want open by hitting ctrl-w. Remember to save the workbook or you'll have to do it again the next time you open it. ajones1978 wrote: I am using Excel 2003 - Version 5.1.2600 Service Pack 2 Build 2600. When I open a particular file, Excel shows that two files are open. They are named the same but end with :1 and :2. Why did this occur and how can I delete one of these? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why did Excel create two identical worksheets?
Thanks very much - that did the trick!
"Kevin B" wrote: You or someone else clicked WINDOW in the menu and selected NEW WINDOW. To remove the extra window click the X close button on the right side of the menu bar to close the extra window and resave the file. (The close window is not the X in the red button on the title bar, which closes the app, but the one below it) -- Kevin Backmann "ajones1978" wrote: I am using Excel 2003 - Version 5.1.2600 Service Pack 2 Build 2600. When I open a particular file, Excel shows that two files are open. They are named the same but end with :1 and :2. Why did this occur and how can I delete one of these? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create an identical Chart Worksheet in Excel 2003 | Charts and Charting in Excel | |||
| HOW TO CREATE 2 IDENTICAL INVOICES ON 1 A4 SHEET | New Users to Excel | |||
| How do I match identical data from two different worksheets in one | New Users to Excel | |||
| Create an Identical Worksheet | Excel Discussion (Misc queries) | |||
| Format all worksheets for identical printing | Excel Discussion (Misc queries) | |||
Linear Mode
