How to zero out all data fields in Microsoft Excel 2003 Spreadsheet

I have a customer with a Microsoft Excel Spreadsheet problem.  He  does a yearly budget.  When he gets to the end of the year he wants to keep the template for next year, with all the header's, etc, but with all the data fields zeroed out.  Is there any way to do this, still keeping the formatting, without having to zero each field individually?
Thanks,
Al
Alan SilvermanOwnerAsked:
Who is Participating?
 
Saurabh Singh TeotiaConnect With a Mentor Commented:
Select the data where 0 need to be made...for example...zero need to be done from b coloumn row number 2 to l column till row number 600...

Once the data is selected...Do Ctrl+H

Then in find what just write * nothing else..

and then in replace with write 0  only..

This will do the trick for u...
0
 
chrisezardConnect With a Mentor Commented:
The quickest way to select the cells you need to clear is...
Highlight a sheet or range you want to clear. Press F5 (GoTo).  Press the 'Special...' button. Select 'Constants' and check the 'Numbers' check box. Now you have all the numbers that are not formulas highlighted. Press delete. Then do as saurabh726 suggests, pressing the 'Replace All' button.

Good Luck, Chris
0
 
Alan SilvermanOwnerAuthor Commented:
Thanks, I'll give it a try.
Al
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
chrisezardCommented:
A couple more points...
When you select 'Numbers' from the list of Constants make sure all the others are unchecked.
Either do NOT press Delete and then do Ctrl+H with * in top box and 0 in lower box.
Or DO press Delete and then do Ctrl+H with the top box empty and 0 in lower box.

Chris
0
 
Alan SilvermanOwnerAuthor Commented:
Worked like a charm.  Thanks to both of you.
Al
0
 
chrisezardCommented:
Thanks, Al
These are my first EE points! I am a dedicated asker and searcher of questions, mostly to do with Access VBA. The night you asked your question I was bored and had a look at open Excel questions, which I normally would not do. Your question stood out - as an accountant I've grappled with many budget spreadsheets in the past :)
Chris
0
 
Alan SilvermanOwnerAuthor Commented:
Well congratulations on your first points.  They helped a lot (and made my customer happy.)
Thanks again,
Al
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.