Resetting All Values to Zero in Excel

Next Video:
How to Add on Excel....5

Resetting all values to zero in Excel is something that you can do if you're just about to import new information. Reset all values to zero in Excel with help from a mechanical engineer with 32 years of experience in a large aerospace company in this free video clip.

Part of the Video Series: Using Excel
Promoted By Zergnet


Video Transcript

Hi, I'm Ted. Today, I'm going to show you how to reset all values to zero in an Excel spreadsheet. This is something you might want to do let's say at the end of the year you've got a spreadsheet where you're keeping track of your production or your sales and you want to start fresh with a new spreadsheet. So I have such a spreadsheet here and it's just a very simple thing with two columns. The week first day of the week and then the number of widgets produced in the week. Let's say I want to give this spreadsheet to somebody with everything all blanked out. Now it wouldn't take that long to go through and enter zero in all of them but let's say you had a humongous spreadsheet and you want to do is very quickly. What you do is you select all of the values, so you basically just take your mouse and select all the values and then type in a zero and then the most important step and may be a little different on a Windows machine. On a Macintosh, hold the option key down and hit a return and right away we've got to scroll to the top here to see what happened. Sure enough everything got set to zero. So I hope this has been helpful. I'm Ted and today I showed you how to reset multiple cells to zero in Excel. Thanks for watching.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!