Tricks to Highlights all the blank cells from sheet given?

Hi Guest

MobileUser

HomePage

Jobs

WalkIn

Articles

:) Latest Topic

AJAX

VB.NET

SQL Query

UDDI

CLASS

JavaScript Questions

SharePoint Interview

SilverLight

WCF

general knowledge

ASP.NET

:) Hot Jobs

:) Latest Articles

Tricks to Highlights all the blank cells from sheet given?
Question Posted on 23 Aug 2021

Home >> Microsoft Products >> Microsoft Excel >> Tricks to Highlights all the blank cells from sheet given?

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