Clear data but leave formulas

  • Thread starter Thread starter Jeff Granger
  • Start date Start date
J

Jeff Granger

Starting a new financial year I want to clear all last year's data from a
table, but leave the formulas and formatting.

Any suggestions?

Jeff
 
Hi Jeff,

Edit>Go To>Special. Check Constants and Numbers and/or Text
Edit>Clear>Contents

Make sure you have a copy of the file available!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Starting a new financial year I want to clear all last year's data from a
| table, but leave the formulas and formatting.
|
| Any suggestions?
|
| Jeff
|
|
 
Back
Top