Bookmark page
Printable version
Course updates
|
RSS feeds
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:
- Toggle Formulas and Results
- Adding up rows or columns without seeing formulas
- Excel 2010 Shortcuts - Start and End of the Worksheet
 |
|
» Forum post: Macro |
How do i record please
