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.
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.
Trainer Bc. Petr Vadlejch since 2007 specializes in trainings of Microsoft Office Applications and is a certified specialist in Microsoft Office.
Vyřešilo by to i podmíněné formátování
Ano to je pravda. Výběr prázdných buněk metodou ukazovanou ve videu ale lze buňky i vyplnit, viz doplnění článku.