Following the techniques used in the previous post , we can perform many Excel magics for different scenarios. On top of my mind is to replace blank cells with zero.
The first task is to select all blank cells in the range. We can do so by using the following shorcuts:
Ctrl+A => Ctrl+G => Alt+S => k => Enter
(Note: select any cell in the range first)
With all the blank cells selected, the trick is to enter “0” or any values or texts or even formula and then confirm by pressing CTRL+Enter.
As simple as this! 😎
Another approach doing the same task is Find and Replace. Simply
- Select the range with blanks
- Ctrl+H to open Find and Replace dialog box
- Leave it blank in “Find what”; enter 0 in “Replace with”
- Replace all
Done Done Done Done 😁
Watch it in action on my YouTube channel:
I hope you like it. If you do, please give a thumb up, share and subscribe. 😉
wmfexcel 