worksheet/file name :1 :2

[Carrie]

hi,

when i open up a file...i have two worksheets in that file
one is :1 and the other is :2.

how do I get rid of one of these??

thanks,

carrie

 

[FSt1]

hi
on the menu bar...
edit>Delete sheet

are you talking about a new workbook? if so
on the menu bar...
tools>options>general tabs>sheet in a new workbook.
this will set how many sheets any new workbook will have.

Regards
FSt1

 

[Carrie]

no, when i open up the file,
I have two workbooks that have the same information on them,
and when i enter information on one, it goes to the second one...
up on the far left with the name of the file, one says filename:1
and the other one says filename:2

 

[Dave Peterson]

hi,

when i open up a file...i have two worksheets in that file
one is :1 and the other is :2.

how do I get rid of one of these??

thanks,

carrie

 

[Dave Peterson]

It's actually two different windows or views into the same workbook.

Select the window you don't want and hit ctrl-w.

Then save the workbook--or you'll be doing it again.

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