Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default worksheet/file name :1 :2

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default worksheet/file name :1 :2

hi
on the menu bar...
editDelete sheet

are you talking about a new workbook? if so
on the menu bar...
toolsoptionsgeneral tabssheet in a new workbook.
this will set how many sheets any new workbook will have.

Regards
FSt1

"Carrie" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 68
Default worksheet/file name :1 :2

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



"FSt1" wrote:

hi
on the menu bar...
editDelete sheet

are you talking about a new workbook? if so
on the menu bar...
toolsoptionsgeneral tabssheet in a new workbook.
this will set how many sheets any new workbook will have.

Regards
FSt1

"Carrie" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default worksheet/file name :1 :2



Carrie wrote:

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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default worksheet/file name :1 :2

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

Carrie wrote:

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set up a worksheet name as file name Sunil Pal Excel Discussion (Misc queries) 1 March 21st 08 04:40 AM
Worksheet to new file jai Excel Discussion (Misc queries) 1 August 25th 07 07:36 AM
copy part of a worksheet into a worksheet in the same file/keepi. JTB Excel Worksheet Functions 1 September 23rd 06 09:13 AM
Saving worksheet in new file with date AND cell value as file name michaelberrier Excel Discussion (Misc queries) 4 May 26th 06 08:05 PM
How to get file name on a worksheet? UNNI New Users to Excel 2 February 15th 06 10:09 AM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"