Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set up a worksheet name as file name | Excel Discussion (Misc queries) | |||
Worksheet to new file | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
How to get file name on a worksheet? | New Users to Excel |