Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

worksheet/file name :1 :2

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carrie - 20 May 2008 18:25 GMT
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 - 20 May 2008 18:49 GMT
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

> hi,
>
[quoted text clipped - 6 lines]
>
> carrie
Carrie - 20 May 2008 18:58 GMT
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

> hi
> on the menu bar...
[quoted text clipped - 18 lines]
> >
> > carrie
Dave Peterson - 20 May 2008 19:47 GMT
> hi,
>
[quoted text clipped - 6 lines]
>
> carrie

Signature

Dave Peterson

Dave Peterson - 20 May 2008 19:47 GMT
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

> hi,
>
[quoted text clipped - 6 lines]
>
> carrie

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.