Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
RE: in xl..how to delete data and leave formulas
0 views
Skip to first unread message
FSt1
Nov 9, 2009, 4:40:01 PM11/9/09
to
hi
select the sheet you want to delete data. press the F5 key to bring up the
goto dialog. click the special button. form the list select constrants. ok
all data that is not a formula should be high lighted. press the delete key.
data gone, formulas still there.
select the sheet you want to delete data. press the F5 key to bring up the
goto dialog. click the special button. form the list select constrants. ok
all data that is not a formula should be high lighted. press the delete key.
data gone, formulas still there.
Regards
FSt1
"Graywolf" wrote:
> have multiple sheet workbook with formulas that refer to previous work sheet.
> Need to delete data with out erasing formuas ???
>
0 new messages