YOU CAN DOWNLOAD ALL MY FILES FOR FREE AT www.theexcelchallenge.com
Learn a quick trick to fill out several blank cells (empty cells) all at once by using the Replace command. It can be annoying for the reader of your information to see blank cells, only causing the reader to wonder whether the values are actually zeros, or are actually "not applicable", or the cells were left blank by mistake.
If you have a few cells, you may just want to correct one by one manually, but if you have hundreds or thousands of empty cells you would like to fill out all at once, then this trick will come in handy.
I hope this trick is something you can use in your daily routine so you get more with less effort.
If you have an Excel challenge that you need help with, whether it is at work, at home, or at school, please write it in the comments below. I try to resolve common Excel challenges from our viewers and subscribers.
Thank you for watching.
Check out some of our previous videos in the links below:
* TECH-009 - Create a TOP 5 chart (Pareto) that updates automatically
• TECH-009 - Create a TO...
* TECH-008 - Create a chart with stacked pictures
• TECH-008 - Create a ba...
* TECH-007 - Create a survey in Excel using option buttons (a.k.a. radio buttons)
• TECH-007 - Create a su...