how to clear data

[chrisk]

How can I clear data from a worksheet with out erasing the formulas?
I want to reuse last years sheet for this year. So how can I clear the data
with out erasing the formula?

Thanks

 

[Max]

Select all* the ranges (hold down CTRL to select discontiguous ranges)
Then press F5 > Special > Check "Constants" > OK
This will focus it only on cells with data. Press Delete key to clear at one
go.

*In selecting the ranges, try as far as possible to exclude text labels, col
headers etc ie data that you want to retain
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik

 

[Gary''s Student]

Edit > GoTo > Special > Constants

and then clear

 

[MartinW]

Hi Chris,

Just to add to the other replies,
After you have gone to F5>Special>Constants
You will most likely need to Uncheck Text, Logicals and Errors,
and leave Numbers Checked.

The dialog box is a little confusing as these options appear under
the Formulas heading, but they work for Constants as well.

HTH
Martin