How do I get rid of duplicate spreadsheets?

[louise]

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?

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[JE McGimpsey]

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

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

 

[FSt1]

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

 

[Dave Peterson]

Select the window to close
hit ctrl-w

Save the workbook the way you like.

 

[louise]

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

 

[JE McGimpsey]

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

 

[FSt1]

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]

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]

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