Fill all blank cells in an Excel range with a desired value

Fill all blank cells in an Excel range with a desired value

12 July 2014

Here's a nifty little trick I use every day while working in Excel. It's a two part trick. Part one will be selecting all the blank cells in a range or rather reducing a selection or a range to blank cells within that range. Part two will be how to enter a value or a formula(!) into multiple cells in Excel simultaneously.