ExcelBanter - delete all values in column?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - delete all values in column? (https://www.excelbanter.com/excel-worksheet-functions/94443-delete-all-values-column.html)

L. Irvine

delete all values in column?

Is there a way to delete all values in a colum without deleting formula
cells?

Ron de Bruin

delete all values in column?

Hi L. Irvine

Click on the column header
F5Special
Constants
OK

Delete

--
Regards Ron De Bruin
http://www.rondebruin.nl

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

All times are GMT +1. The time now is 02:29 AM.