ExcelBanter - Excel 2002

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/69275-excel-2002-a.html)

Dean

Excel 2002

What is the quickest way to delete all the data but save the formulas?

Gord Dibben

Excel 2002

Dean

CTRL + a(twice in 2003) to select all cells.

F5SpecialConstantsOK

EditClear Contents.

Gord Dibben MS Excel MVP

On Fri, 3 Feb 2006 03:48:15 -0800, "Dean"
wrote:

What is the quickest way to delete all the data but save the formulas?

will A

Excel 2002

COPY, select another range or wks, EDIT, SPECIAL, FORMULA.

"Dean" wrote:

What is the quickest way to delete all the data but save the formulas?

All times are GMT +1. The time now is 04:08 PM.