Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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!

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
Big problem with excel recalculating spreadsheet Prometheus Excel Discussion (Misc queries) 2 August 9th 06 07:50 PM
Linked Spreadsheet Opens CarlaInJax Excel Discussion (Misc queries) 0 July 25th 06 05:17 PM
summarize data from one spreadsheet to other spreadsheet sa02000 Excel Worksheet Functions 10 June 27th 06 07:10 PM
Working spreadsheet highlighting function for Excel 2007 Mr. Low Excel Worksheet Functions 4 June 16th 06 06:12 PM
Spreadsheet merging problems Sam B Excel Worksheet Functions 0 September 19th 05 08:05 PM


All times are GMT +1. The time now is 12:21 AM.

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"