98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Highlighting only Text cells

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)


In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

Added by Meenesh on 5th October 2006

More Excel hints and tips, like:

• Selecting your working range
• Percentage format
• removing border lines on the keyboard