Solved

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

Posted on 2007-12-03
7
878 Views
Last Modified: 2010-05-18
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
0
Comment
Question by:alanlsilverman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 250 total points
ID: 20399141
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
 
LVL 1

Assisted Solution

by:chrisezard
chrisezard earned 250 total points
ID: 20399721
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
 

Author Comment

by:alanlsilverman
ID: 20400322
Thanks, I'll give it a try.
Al
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 1

Expert Comment

by:chrisezard
ID: 20402177
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
 

Author Closing Comment

by:alanlsilverman
ID: 31412442
Worked like a charm.  Thanks to both of you.
Al
0
 
LVL 1

Expert Comment

by:chrisezard
ID: 20486555
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
 

Author Comment

by:alanlsilverman
ID: 20486642
Well congratulations on your first points.  They helped a lot (and made my customer happy.)
Thanks again,
Al
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question