In this lesson, we will learn how to fill empty cells in Excel with one step only.
Assuming we have the following table and we want to fill empty cells in it to distinguish them from the filled cells.
With these steps, we can fill in all the blanks at once without going through them one by one.
I assume that the table shows a group of student marks and that the empty cells are days when the student was absent from the exam.
Click on the table and press “Control + A” from the keyboard to select the entire table.
Then from the toolbar, from “Home”, we choose “Find and Select” and from it, we choose “Go to Special”.
A window appears from which we choose “Blanks”.
Then we click “Ok” and notice that Excel has selected the empty cells with a different color.
We will write in this cell, for example: “N/A”.
Press “Control + Enter” and you will notice that all the boxes now contain the word “N/A”.
Dear reader, if you liked the article, do not forget to subscribe to our YouTube channel, which provides all new in the field of technical and completely free training courses.
You can also browse our website to access the blog and read technical topics, or learn about the training courses offered by the site.
To access the full course “Excel Course” on YouTube, click here.
