Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I delete the data and keep formulas for a whole worksheet?
I keep records of individuals donations for our church . I want to close out
the worksheet for the past year and delete the information but keep all the formulas for compulation of this years data. Can I do this easily? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I delete the data and keep formulas for a whole worksheet?
Select the range ...then press function key F5...click on Special and select
constant. Hit the delete key .. "Annette" wrote: I keep records of individuals donations for our church . I want to close out the worksheet for the past year and delete the information but keep all the formulas for compulation of this years data. Can I do this easily? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I delete the data and keep formulas for a whole worksheet?
hi
press the F5 key. this will bring up the goto dialog click the special button at bottom left. this will bring up the got special dialog check the constrants options. click ok. this should highlight all of your data but not your fomulas. press the delete key. data gone. formulas still there. Regards FSt1 "Annette" wrote: I keep records of individuals donations for our church . I want to close out the worksheet for the past year and delete the information but keep all the formulas for compulation of this years data. Can I do this easily? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep formulas in an Excel template when I delete data | Excel Worksheet Functions | |||
how can I Delete data in a spread sheet and keep formulas | Excel Discussion (Misc queries) | |||
delete data, keep formulas | Excel Discussion (Misc queries) | |||
Delete all data (formulas) below a desired row. | Excel Discussion (Misc queries) | |||
how do I lock formulas, but I can still delete data? | Excel Worksheet Functions |