| Tricks to Highlights all the blank cells from sheet given?
As we all knows excel is capable to handle large ammount of data in it sheets. So it is hard to identify the blank cells from it. SO best way is apply a cell color that will help to display it uniquely.
(1)First we need to select all the sheets by shortcut CTRL + A.
(2)After first step select Home Tab -> Editing -> Find & Select -> Go to Special.
(3)After getting select "Go To Special" then "Blank" as per below screen then click ok.
(4)After this point we will get screen something like below.
| | |