delete all values in column?

  • Thread starter Thread starter L. Irvine
  • Start date Start date
L

L. Irvine

Is there a way to delete all values in a colum without deleting formula
cells?
 
Hi L. Irvine

Click on the column header
F5>Special
Constants
OK

Delete
 
You must log in or register to reply here.

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

Similar Threads

Macro Help 1
Dynamic col_index_num in VLOOKUP? 5
matrix math in excel? 2
adding/omitting/all the values prior to todays date 2
Changing a Formula 1
adding next years value 2
Compare 1 cell to column of cells returning adjacent cells info? 1
copy paste value 1

Back
Top