How to delete a duplicate Excel worksheet within that worksheet?
 

I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid of
it?

How to delete a duplicate Excel worksheet within that worksheet?
 

How many columns are there on the spreadsheet? This will help me understand
the scope of the problem.

Regards.

Bill Ridgeway
Computer Solutions

"jozawun" wrote in message
...
I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid
of
it?

How to delete a duplicate Excel worksheet within that worksheet?
 

How many columns are there on the spreadsheet? This will help me understand
the scope of the problem.

Regards.

Bill Ridgeway
Computer Solutions

"jozawun" wrote in message
...
I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid
of
it?

How to delete a duplicate Excel worksheet within that workshee
 

There are 8 columns actually used, but the Worksheet is infinite, and so is
the "mirror"; ie, in the original, I can scroll across as many columns as I
like, and this just pushes across duplicate column A; and likewise, in the
duplicate, I can scroll across indefinitely.
I should have added originally that whenever I select a cell for any
purpose, the same cell on the duplicate is selected; and whatever I do in
that cell (eg, enter data, delete, whatever) is simaltaneously repeated in
the duplicate cell.

Jozawun

"Bill Ridgeway" wrote:

How many columns are there on the spreadsheet? This will help me understand
the scope of the problem.

Regards.

Bill Ridgeway
Computer Solutions

"jozawun" wrote in message
...
I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid
of
it?

How to delete a duplicate Excel worksheet within that workshee
 

Bill

I'm sorry, I haven't explained this very well. The duplicate is kind of
like a window tiled vertically, but it's not. What it seems to be is an
identical copy which slides horizontally over the top of the original. I can
drag it back and forth almost to the left hand side of the screen or almost
to the right hand side, then work on the original by clicking across
horizontally so that it slides out from under the duplicate. I can also work
on the duplicate with simaltaneous identical changes in the original.

"Bill Ridgeway" wrote:

How many columns are there on the spreadsheet? This will help me understand
the scope of the problem.

Regards.

Bill Ridgeway
Computer Solutions

"jozawun" wrote in message
...
I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid
of
it?

How to delete a duplicate Excel worksheet within that worksheet?
 

Do you see something like: Book1.xls:1 and Book1.xls:2 in the title bars?

If yes, then you haven't duplicated any worksheets. But you have opened a
second window into that same workbook.

If you want to close one, just click on it and hit ctrl-w

Remember to save the workbook before you close--else you'll be doing it again.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.



jozawun wrote:

I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid of
it?

--

Dave Peterson

How to delete a duplicate Excel worksheet within that workshee
 

Thank you

"Dave Peterson" wrote:

Do you see something like: Book1.xls:1 and Book1.xls:2 in the title bars?

If yes, then you haven't duplicated any worksheets. But you have opened a
second window into that same workbook.

If you want to close one, just click on it and hit ctrl-w

Remember to save the workbook before you close--else you'll be doing it again.

Debra Dalgleish has some instructions with pictures:
http://contextures.com/xlfaqApp.html#TwoWindows

This can be caused by using:
Window|New window
(maybe followed by window|arrange)

It can be quite useful to see different ares of the same workbook (even same
worksheet) at the same time.



jozawun wrote:

I have somehow created an identical duplicate "mirror" copy of an entire
Worksheet within that same Worksheet.
Does anyone know, first, how this happened and, secondly, how to get rid of
it?

--

Dave Peterson