HDTutorial
EN
How to Format Only Blank Cells in Excel - Excel Dose

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Format Only Blank Cells in Excel - Excel Dose

297 views November 15, 2019 0:49

Watch on YouTube
ChannelExcel Dose

Description from the creator

Here is the solution:

Just select the cells(blank & non-blank) in Excel and press F5.
A small window will appear, press the button Special.
Another window will appear, select the radio button Blanks and click OK.
After you do the above step, all the non-blank cells will be selected. You can now change their background color. Write something and press Ctrl+Enter. It will be written to all the non-blank cells simultaneously.

#ExcelTricks #ExcelTutorial #ExcelBeginnerGuide

About this tutorial

Excel Dose published this 0:49 video tutorial on November 15, 2019. It has been watched 297 times on YouTube.

Channel
Excel Dose
Category
Education
Duration
0:49
Published
November 15, 2019
Views
297
Likes
5

Share

This tutorial in other languages