Hints and tips home » Excel hints and tips » Select only cell that contain text to lock format

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

Added by Tom on 21st November 2006

More Excel hints and tips, like:

• Go to source of a cell
• Counting Blanks
• Sum Up All the Values in A Column