Microsoft Excel Tips and Tricks
In this Excel video tutorial I explain how to fill blank cells with the value above. This can be achieved using a simple formula – but you need a quick way of selecting all the blank cells and copying the formula to them.
Credit Chester Tugwell