A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HELP needed to remove 2nd spreadsheet within a workbook



 
 
Thread Tools Display Modes
  #1  
Old May 30th, 2010, 03:31 PM posted to microsoft.public.excel.misc
alphaewe
external usenet poster
 
Posts: 1
Default HELP needed to remove 2nd spreadsheet within a workbook

I have a large workbook containing 10 worksheets. It's quite large. Somehow -
and I don't know how, I created a copy of my workbook that open behind (next
to) my original workbook. I can see the copy by dragging a white colume that
appears on the right of my worksbook pages. If I highlight a cell or row in
the original, it also highlihgts (and changes text) in the copy. I need to
know how to get rid of that copy. Don't know how it got created, don't know
how to get rid of it. Will be eternally thankful to anyone who can help me.
  #2  
Old May 30th, 2010, 04:35 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default HELP needed to remove 2nd spreadsheet within a workbook

Most likely caused by WindowNew Window and you now have two views of same
workbook named workbook.xls:1 and workbook.xls:2

Close one of them then save the remaining copy.


Gord Dibben MS Excel MVP

On Sun, 30 May 2010 07:31:01 -0700, alphaewe
wrote:

I have a large workbook containing 10 worksheets. It's quite large. Somehow -
and I don't know how, I created a copy of my workbook that open behind (next
to) my original workbook. I can see the copy by dragging a white colume that
appears on the right of my worksbook pages. If I highlight a cell or row in
the original, it also highlihgts (and changes text) in the copy. I need to
know how to get rid of that copy. Don't know how it got created, don't know
how to get rid of it. Will be eternally thankful to anyone who can help me.


  #3  
Old May 30th, 2010, 04:38 PM posted to microsoft.public.excel.misc
FSt1
external usenet poster
 
Posts: 2,788
Default HELP needed to remove 2nd spreadsheet within a workbook

hi
guessng but it sounds like you have opened a new window.
on the menu barwindownew window. this created a copy of the active file.
at the bottome of the dropdown menu, your file name should appear twice.
to get rid of it......close the new(extra) window. do so by clicking the
small x under the large red x in the upper left of the screen.

regards
FSt1


"alphaewe" wrote:

I have a large workbook containing 10 worksheets. It's quite large. Somehow -
and I don't know how, I created a copy of my workbook that open behind (next
to) my original workbook. I can see the copy by dragging a white colume that
appears on the right of my worksbook pages. If I highlight a cell or row in
the original, it also highlihgts (and changes text) in the copy. I need to
know how to get rid of that copy. Don't know how it got created, don't know
how to get rid of it. Will be eternally thankful to anyone who can help me.

  #4  
Old May 30th, 2010, 04:49 PM posted to microsoft.public.excel.misc
Matrix
external usenet poster
 
Posts: 15
Default HELP needed to remove 2nd spreadsheet within a workbook

Assuming that you are using Word 2007, on the ribbon open view and unselect
"split". If that doesn't work, click on cell A1 on the upper left version.
Then move the mouse to the little white bar next to the scroll arrows. When
the mouse changes to the Up/Down or Left/Right slider icon, left click and
move the bar to the top and/or the right. The split function is a normal
function of Excel. Hope this helps!

"alphaewe" wrote:

I have a large workbook containing 10 worksheets. It's quite large. Somehow -
and I don't know how, I created a copy of my workbook that open behind (next
to) my original workbook. I can see the copy by dragging a white colume that
appears on the right of my worksbook pages. If I highlight a cell or row in
the original, it also highlihgts (and changes text) in the copy. I need to
know how to get rid of that copy. Don't know how it got created, don't know
how to get rid of it. Will be eternally thankful to anyone who can help me.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.