ExcelBanter - how do i clear data in excel and not lose the formula

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i clear data in excel and not lose the formula (https://www.excelbanter.com/excel-worksheet-functions/96943-how-do-i-clear-data-excel-not-lose-formula.html)

petecook

how do i clear data in excel and not lose the formula

how do i clear data in excel and not lose the formula

Gord Dibben

how do i clear data in excel and not lose the formula

F5SpecialConstants.

Check or uncheck which constants you don't want selected, like maybe Text which
is used for titles.

OK your way out and EditClear Contents.

Gord Dibben MS Excel MVP

On Thu, 29 Jun 2006 17:46:01 -0700, petecook
wrote:

how do i clear data in excel and not lose the formula

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