Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Fomula
How do I clear a spreadsheet (or columns) but retain the formulas to be used
over and over for different projects? |
#2
|
|||
|
|||
Ninfa, one way, edit, goto, special, check constants, OK, then delete
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ninfa" wrote in message ... How do I clear a spreadsheet (or columns) but retain the formulas to be used over and over for different projects? |
#3
|
|||
|
|||
Thanks Paul, but what I do if I'm using Excel 2000? It doesn't have special
under edit. Ninfa "Paul B" wrote: Ninfa, one way, edit, goto, special, check constants, OK, then delete -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ninfa" wrote in message ... How do I clear a spreadsheet (or columns) but retain the formulas to be used over and over for different projects? |
#4
|
|||
|
|||
Paul said editgoto, then click special etc You can also press shortcut F5,
then special and constants etc Regards, Peo Sjoblom "Ninfa" wrote in message ... Thanks Paul, but what I do if I'm using Excel 2000? It doesn't have special under edit. Ninfa "Paul B" wrote: Ninfa, one way, edit, goto, special, check constants, OK, then delete -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ninfa" wrote in message ... How do I clear a spreadsheet (or columns) but retain the formulas to be used over and over for different projects? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |