1.

Tricks to Highlights all the blank cells from sheet given?

Answer»

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.


Excel DataSheet

(2)After first step select Home Tab -> Editing -> Find & Select -> Go to Special.


Excel GoToSpecial

(3)After getting select "Go To Special" then "Blank" as per below screen then CLICK ok.


Excel Blank

(4)After this POINT we will get screen something like below.


Excel HighLight Cell



Discussion

No Comment Found