Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Formulas while deleting rows
Is it possible to protect and entire column of formulas in a sheet while
still allowing the DELETION of rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Formulas while deleting rows
hi
your request seems contradictory. if you want to keep a certain column then you're not accually deleting rows, just the data on both sides of the column. is that what you want? just delete the data on both sides of the fomula column? if so, do this..... highlight the "rows" that you want to delete. press the F5 key(GoTo) click the special button. select constrants. click OK. all of your non-formula data should be highlighted. press the delete key. VIOLA!!!! ! data gone, formulas still there. regards FSt1 "RLD" wrote: Is it possible to protect and entire column of formulas in a sheet while still allowing the DELETION of rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows with formulas is very slow | Excel Discussion (Misc queries) | |||
Way to keep formulas unchanged when deleting rows? | Excel Discussion (Misc queries) | |||
protect from deleting rows | Excel Discussion (Misc queries) | |||
Question about deleting rows and formulas | Excel Discussion (Misc queries) | |||
deleting rows--calculating formulas with each row as it goes? | Excel Discussion (Misc queries) |