Clear Data not formulas

walcon

New Member
Joined
Aug 6, 2010
Messages
3
Can I clear the data from selected cells and leave the formulas intact?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

Sure. Goto CRTL+G-->Special-->Check the Constants button. Once you do that all of the non-formula cells will be selected and you can then delete them. You can also record a macro doing it if you want to repeat it in the future.

HTH,
 

walcon

New Member
Joined
Aug 6, 2010
Messages
3
Thanks Smitty,

Can I modify it to just clear the cells that I select, and then record it in a Macro?
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
If you're referring to manually selcting cells to clear, then sure. The recorder will capture that.
 

walcon

New Member
Joined
Aug 6, 2010
Messages
3
Thanks Again Smitty,

My apologies for not being clear with my "First Post". What I want is to clear the contents of cells containing formulas, but not clearing the formulas.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Thanks Again Smitty,

My apologies for not being clear with my "First Post". What I want is to clear the contents of cells containing formulas, but not clearing the formulas.

Then you'll need to clear their dependent cells, which may be a bit more complicated. Can you define them?
 

Watch MrExcel Video

Forum statistics

Threads
1,132,679
Messages
5,654,714
Members
418,149
Latest member
tjanok

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top