ExcelBanter - how can I Delete data in a spread sheet and keep formulas

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

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

- - how can I Delete data in a spread sheet and keep formulas (https://www.excelbanter.com/excel-discussion-misc-queries/196054-how-can-i-delete-data-spread-sheet-keep-formulas.html)

Excel Dummy

how can I Delete data in a spread sheet and keep formulas

how can I Delete data in a spread sheet and keep formulas

Gord Dibben

how can I Delete data in a spread sheet and keep formulas

F5SpecialConstantsOKEditDelete

You may want to uncheck the "Text" option if you have titles to retain.

Gord Dibben MS Excel MVP

On Wed, 23 Jul 2008 18:23:02 -0700, Excel Dummy <Excel
wrote:

how can I Delete data in a spread sheet and keep formulas

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