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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top