6. Videotutorial – select blank cells

I have prepared another video; and this time we are back to Excel, which will introduce a quick tweaks to select empty cells. You need the table quickly find and select blank cells? This trick saves a lot of time. See one minute video and everything also try on the attached file. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too.

Please note that this tutorial is presented in czech language, with english subtitles.

Source file can be downloaded here.

Inserting values into empty cells

In addition to coloring, this procedure may also be applied eg. for filling empty cells with specified value.

After selecting the blank cells using the procedure mentioned in the video just type in the formula bar a formula or value, and for insertion into all selected cells at once use the key combination Ctrl + Enter.