|
Posted to microsoft.public.excel.misc
|
|
|
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
|