ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get rid of duplicate spreadsheets? (https://www.excelbanter.com/excel-discussion-misc-queries/187470-how-do-i-get-rid-duplicate-spreadsheets.html)

Louise

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?

Peo Sjoblom

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?




JE McGimpsey

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?


FSt1

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?


Dave Peterson

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

Louise

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?


JE McGimpsey

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!


FSt1

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?


Louise

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?


FSt1

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?



All times are GMT +1. The time now is 03:44 PM.

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