Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2:2
i was working with a file named route2 and somehow it changed to route2_2:1
and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2:2
Paul
These are just windows of the same file (WindowNew), just close one, you are not closing the file, just the window and then save the file -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... i was working with a file named route2 and somehow it changed to route2_2:1 and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2
Thanks for the reply Nick. On my memory stick the file shows as route 2. When
I open it it opens up as route 2:1 and route 2:2 under the window drop down. I tried closing one of the files but it closes both versions at he same time so I cannot save the original. Any other suggestion and how did I create this mess? "Nick Hodge" wrote: Paul These are just windows of the same file (WindowNew), just close one, you are not closing the file, just the window and then save the file -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... i was working with a file named route2 and somehow it changed to route2_2:1 and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2
If you're displaying the 2:2 window, and you hit:
<Ctrl <W You'll see the 2:2 change to 2, meaning you closed *only* the duplicate window. NOW, save the file while there's *no :2*. As Nick explained, Each time you click (accidentally or intentionally), <Window <New Window, You create a *copy* of the sheet. This is great for being able to display different sections of the same sheet *or* file at the same time, by going back into <Window, and choosing <Arrange, and configuring your screen to different display modes. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Paul" wrote in message ... Thanks for the reply Nick. On my memory stick the file shows as route 2. When I open it it opens up as route 2:1 and route 2:2 under the window drop down. I tried closing one of the files but it closes both versions at he same time so I cannot save the original. Any other suggestion and how did I create this mess? "Nick Hodge" wrote: Paul These are just windows of the same file (WindowNew), just close one, you are not closing the file, just the window and then save the file -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... i was working with a file named route2 and somehow it changed to route2_2:1 and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2
Paul
Just click the red 'x' just below the top 'x' which closes the application and you should still have one window open, save in this state -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... Thanks for the reply Nick. On my memory stick the file shows as route 2. When I open it it opens up as route 2:1 and route 2:2 under the window drop down. I tried closing one of the files but it closes both versions at he same time so I cannot save the original. Any other suggestion and how did I create this mess? "Nick Hodge" wrote: Paul These are just windows of the same file (WindowNew), just close one, you are not closing the file, just the window and then save the file -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... i was working with a file named route2 and somehow it changed to route2_2:1 and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete duplicate file example route 2_2:1 or route 2_2
Thanks you solved my problem
"Ragdyer" wrote: If you're displaying the 2:2 window, and you hit: <Ctrl <W You'll see the 2:2 change to 2, meaning you closed *only* the duplicate window. NOW, save the file while there's *no :2*. As Nick explained, Each time you click (accidentally or intentionally), <Window <New Window, You create a *copy* of the sheet. This is great for being able to display different sections of the same sheet *or* file at the same time, by going back into <Window, and choosing <Arrange, and configuring your screen to different display modes. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Paul" wrote in message ... Thanks for the reply Nick. On my memory stick the file shows as route 2. When I open it it opens up as route 2:1 and route 2:2 under the window drop down. I tried closing one of the files but it closes both versions at he same time so I cannot save the original. Any other suggestion and how did I create this mess? "Nick Hodge" wrote: Paul These are just windows of the same file (WindowNew), just close one, you are not closing the file, just the window and then save the file -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Paul" wrote in message ... i was working with a file named route2 and somehow it changed to route2_2:1 and route2_2:2. How do I delete the new files and return to the origina?. How did I create the new files???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
I WANT TO DELETE A WIDE OF DATE IN A EXCEL FILE | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
How do I Delete a file from the drop down file menu? | Excel Worksheet Functions |