DEFINITION:- The Go To Special Function In Excel Allows You To Quickly Select All Cells That Meet Certain Criteria, Such As Cells Containing: Comments, Constants, Formulas (Numbers, Text, Logical, Errors), Blank Cells, Objects Etc.
- Blank Will Select The Blank Cell Only.
- Current Region Will Select From The Active Cell To Last Row. makes Sure You Don’t Have A Blank Cell Otherwise It Will Consider Above The Blank Row As Last Row.
- Current Array Will Select The Active Range Belongs To.
- Object Will Select Any Object Available In A Range. Ex:- Shapes
- Last Cell Will Select The Last Used Cell In A Worksheet. Even If You Delete The Data From Cell.
- Visible Cells Will Select Only Visible Cell If Any Filter Is Applied Or Even Any Row Or Columns Are Available.
- Conditional Formatting Will Select The Format Data Cell In A Worksheet.
- Data Validation Will Allow To Select Validation Available Cells In A Worksheet.
STEPS :
- Home Tab – Find & Select – Choose “Go To Special…”
- Select “Constant” And Choose “Numbers” It Will Select The Number Cells Only
- Select “Constant” And Choose “Text” It Will Select The Text Cells Only
- Select “Constant” And Choose “Logical” It Will Select The Logical Formula Cells Only
- Select “Constant” And Choose “Errors” It Will Select The Errors Cells Only
3. Click “Ok” To Get The Result.
