Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete duplicate entries in excel? | New Users to Excel | |||
How do I delete duplicate records from an entire Excel workbook? | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how to delete an excel file? how to e-mail a worksheet? | New Users to Excel |