ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I eliminate :1 or :2 of a spreadsheet? (https://www.excelbanter.com/excel-discussion-misc-queries/109353-how-do-i-eliminate-1-2-spreadsheet.html)

tgqk00c

How do I eliminate :1 or :2 of a spreadsheet?
 
Somehow I created a duplicate spreadsheet, but can't delete it without
deleting the original. They open and close simultaneously. I simply want to
eliminate the :2 version. It's annoying and confusing to anyone that doesn't
realize what they may be looking at. Honestly don't know how I even created
it.

When I open 'file Name.xls' it opens both 'file Name:1.xls' and 'file
Name:2.xls'.

Thanks!

Kevin B

How do I eliminate :1 or :2 of a spreadsheet?
 
You probably click Window/New Window as some point. To return to a single
window goto any window other than 1:1, and click the Close Window command
button in the upper righthand corner of the active window, not the close
application button in the application title bar.
--
Kevin Backmann


"tgqk00c" wrote:

Somehow I created a duplicate spreadsheet, but can't delete it without
deleting the original. They open and close simultaneously. I simply want to
eliminate the :2 version. It's annoying and confusing to anyone that doesn't
realize what they may be looking at. Honestly don't know how I even created
it.

When I open 'file Name.xls' it opens both 'file Name:1.xls' and 'file
Name:2.xls'.

Thanks!


tgqk00c

How do I eliminate :1 or :2 of a spreadsheet?
 
So simple, yet I couldn't figure it out myself.

Thanks - I found this very helpful. I was getting rather frustrated. Not
even our IS support could help me.

"Kevin B" wrote:

You probably click Window/New Window as some point. To return to a single
window goto any window other than 1:1, and click the Close Window command
button in the upper righthand corner of the active window, not the close
application button in the application title bar.
--
Kevin Backmann


"tgqk00c" wrote:

Somehow I created a duplicate spreadsheet, but can't delete it without
deleting the original. They open and close simultaneously. I simply want to
eliminate the :2 version. It's annoying and confusing to anyone that doesn't
realize what they may be looking at. Honestly don't know how I even created
it.

When I open 'file Name.xls' it opens both 'file Name:1.xls' and 'file
Name:2.xls'.

Thanks!



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

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