Clearing columns but not formulas

[Araley]

How can you clear a column and not clear a formula?

[benishiryo]

hi araley, u may highlight the range, & click Ctrl + G (GoTo Function). Choose "Constant" & click OK. Attached some screenshots.

[shekhar1660]

Hi Araley,

You can follow these steps:

1) Select your range
2) Press F5
3) Click on Special
4) Click on Constants
5) Click on Ok
6) Now you can press "Delete" button from your keyboard to remove the cells (doesn't contain any formula).

Shekhar Sharma