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

G

Gord Dibben

F5>Special>Constants>OK>Edit>Delete

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
 
Top