Selecting cells that only contain Text in Microsoft Excel

» Selecting cells that only contain Text in Microsoft Excel

VERSIONS: All Microsoft Excel Versions

By selecting cells that only contain text, you can distinguish between cells containing different types of data, which allows you to delete, fill or lock cells by type.
Technique 1

Press F5, or choose Edit, Go To…;
In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

Technique 2 - Conditional
Formatting

Select the data area.
From the Format menu, select Conditional Formatting.
In Condition 1, select Formula Is.
In the Formula Box, enter the formula =Istext(A1).
Click Format..., choose any format from the Format Cells dialog box, and click OK.
Click OK.

Screenshot // Selecting cells that only contain Text in Microsoft Excel

Rate this tip



1	2	3	4	5

RATING: 3.13
VIEWS: 59171

Email Tip

Print Tip

Add to My Tips

No comments have been submitted.

Sponsors:

Book Store:

VIEW ALL BOOKS

Recommended Books:

Related MS EXCEL TIPS:

Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.