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

  • Thread starter Thread starter Excel Dummy
  • Start date Start date
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
 
Back
Top