Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Worksheets XLS:1 and XLS:2
I have no idea what I did and nobody in my company knows this answer....
someone plesae help!! I have a worksheet that when I open I get two copies of it for instance mayquery.xls:1 and mayquery.xls:2 I don't need two copies and I am not sure how to close or get rid of the second copy. Does anyone have that answer??? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Worksheets XLS:1 and XLS:2
you acidently hit <Window<new Window
just select one of them and click on the red x at the top right of that window. (not of EXCEl just that window. you will be left with one copy without the -1 or -2. Save it even if you have made no changes or when you open it again the two copies will open. It is a useful tool, but can be annoying when you don't expect it. "Howeecow" wrote: I have no idea what I did and nobody in my company knows this answer.... someone plesae help!! I have a worksheet that when I open I get two copies of it for instance mayquery.xls:1 and mayquery.xls:2 I don't need two copies and I am not sure how to close or get rid of the second copy. Does anyone have that answer??? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Worksheets XLS:1 and XLS:2
Thank you BJ
That is perfect! Something so simple!! "bj" wrote: you acidently hit <Window<new Window just select one of them and click on the red x at the top right of that window. (not of EXCEl just that window. you will be left with one copy without the -1 or -2. Save it even if you have made no changes or when you open it again the two copies will open. It is a useful tool, but can be annoying when you don't expect it. "Howeecow" wrote: I have no idea what I did and nobody in my company knows this answer.... someone plesae help!! I have a worksheet that when I open I get two copies of it for instance mayquery.xls:1 and mayquery.xls:2 I don't need two copies and I am not sure how to close or get rid of the second copy. Does anyone have that answer??? Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Duplicate Worksheets XLS:1 and XLS:2
You have two windows open with the same file.
Someone inadvertantly clicked on WindowNew Window. Select one of the windows and Close to have one Window remaining. Save that. Gord Dibben MS Excel MVP On Mon, 4 Jun 2007 11:12:00 -0700, Howeecow wrote: I have no idea what I did and nobody in my company knows this answer.... someone plesae help!! I have a worksheet that when I open I get two copies of it for instance mayquery.xls:1 and mayquery.xls:2 I don't need two copies and I am not sure how to close or get rid of the second copy. Does anyone have that answer??? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate entries in multiple worksheets | Excel Worksheet Functions | |||
How do I duplicate value in multiple worksheets in same workbook? | Excel Discussion (Misc queries) | |||
Finding DUplicate Data set in Worksheets | Excel Worksheet Functions | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
how do i look through worksheets in a workbook to find duplicate | Excel Worksheet Functions |