Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 217
Default How do I get rid of duplicate spreadsheets?

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default How do I get rid of duplicate spreadsheets?

Just close the window with the duplicate and then save the workbook


--


Regards,


Peo Sjoblom


"louise" wrote in message
...
I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can
I
delete these?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default How do I get rid of duplicate spreadsheets?

New Window creates a new *window* into the sheet, not a new sheet.

Just close one window (e.g., click on the close button).

In article ,
louise wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do I get rid of duplicate spreadsheets?

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1

"louise" wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default How do I get rid of duplicate spreadsheets?

Select the window to close
hit ctrl-w

Save the workbook the way you like.

louise wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 217
Default How do I get rid of duplicate spreadsheets?

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!

"FSt1" wrote:

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1

"louise" wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default How do I get rid of duplicate spreadsheets?

Click the X in the *document* window, not the *application window*.


In article ,
louise wrote:

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!

  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do I get rid of duplicate spreadsheets?

hi
should have read more carefully. if you are comparing 2 seperated file then
you don't create a new window, you just arrange-tiled. do you have 2 files
open? or are you trying to tile 2 sheets in the same file. if so you may be
creating new sheets. are all the sheets the same? same data?

regards
FSt1

"louise" wrote:

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!

"FSt1" wrote:

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1

"louise" wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 217
Default How do I get rid of duplicate spreadsheets?

Sometimes when I choose arrange-tile nothing happens. These are 2 separate
workbooks. The data is the same in all the windows of the one workbook that
is duplicated. I tried to delete sheet but since all the pages in the
workbook are linked, the links disappear.

"FSt1" wrote:

hi
should have read more carefully. if you are comparing 2 seperated file then
you don't create a new window, you just arrange-tiled. do you have 2 files
open? or are you trying to tile 2 sheets in the same file. if so you may be
creating new sheets. are all the sheets the same? same data?

regards
FSt1

"louise" wrote:

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!

"FSt1" wrote:

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1

"louise" wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default How do I get rid of duplicate spreadsheets?

hi
i'm getting more confused my the post. we are in troubleshoot mode.
what happen when you close the file? close xl? do all of the sheet return?
what is excel calling all the new sheets?

regards
FSt1

"louise" wrote:

Sometimes when I choose arrange-tile nothing happens. These are 2 separate
workbooks. The data is the same in all the windows of the one workbook that
is duplicated. I tried to delete sheet but since all the pages in the
workbook are linked, the links disappear.

"FSt1" wrote:

hi
should have read more carefully. if you are comparing 2 seperated file then
you don't create a new window, you just arrange-tiled. do you have 2 files
open? or are you trying to tile 2 sheets in the same file. if so you may be
creating new sheets. are all the sheets the same? same data?

regards
FSt1

"louise" wrote:

When I click the "X" it closes excel. I now have 25 windows of the same
spreadsheet workbook. HELP!

"FSt1" wrote:

hi,
technically you don't delete, you just close the window.
you know the big red "X" in the upper right corner of the screen. click
it...gone.

regards
FSt1

"louise" wrote:

I compare 2 separate spreadsheets. To do this I go to window, new window,
arrange, tile. Consequently it creates a duplicate spreadsheet. How can I
delete these?

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
Spreadsheets delveeny Excel Worksheet Functions 0 February 29th 08 03:47 PM
Comparing 2 spreadsheets to remove duplicate names Marc Hamel Excel Discussion (Misc queries) 2 December 6th 07 03:21 PM
spreadsheets jill Excel Worksheet Functions 1 July 6th 07 05:18 AM
How do you delete duplicate addresses, but keep duplicate names? Shelly Excel Discussion (Misc queries) 1 August 28th 06 10:36 PM
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? EXCEL WORKS CONFUSED Excel Discussion (Misc queries) 4 August 18th 06 11:21 PM


All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"