Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I clear contents in my workbook w/o loosing my formulas?
I have saved my wookbook, using save as from another file.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I clear contents in my workbook w/o loosing my formulas?
=IF(OR(A2:A5000={200000,300000,400000}),"YES","NO" )
ctrl+shift+enter, not just enter "Julie E" wrote: I have saved my wookbook, using save as from another file. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I clear contents in my workbook w/o loosing my formulas?
Julie,
I think we've lost what it is you don't want to lose... Please include full explanation in the text. I'm not sure if Teethless mama was responding to you or possibly someone else and accidentally got here. Explain a little more if you don't already have the answer and we'll give it a go. "Julie E" wrote: I have saved my wookbook, using save as from another file. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I clear contents in my workbook w/o loosing my formulas?
If you want to clear ALL inputs from the sheet without erasing any formulas....
Maybe something like this: Select only 1 cell Then...From the Excel main menu: Press [F5].....(that's the shortcut for <edit<go to) Click the [Special] button Check: Constants Click the [OK] button (that should select all input cells with values) Press the [delete] key to erase the contents of those cells Does that help? *********** Regards, Ron XL2002, WinXP "Julie E" wrote: I have saved my wookbook, using save as from another file. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I clear contents in my workbook w/o loosing my formulas?
Julie
CTRL + a(twice in 2003) and F5SpecialConstants. Select the costants you want to keep and OK EditClear Contents. Gord Dibben MS Excel MVP On Fri, 29 Dec 2006 08:58:00 -0800, Julie E <Julie wrote: I have saved my wookbook, using save as from another file. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One workbook to another . . . | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Excel Formulas getting information from 1 workbook to another | Excel Worksheet Functions | |||
Copying CONTENTS not Formulas | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel |