Change text in worksheet to all caps

J

Jackie Graham

I need to change a very large worksheet to have all the
text in caps lock. I can change one cell only with the
UPPER function but I don't know how to do it for the
entire worksheet. Help
 
D

DAVEBALL

You might download ASAP Utilities. It's a free set of utilities with
great many helpful functions (one of which allows you to change al
selected cells to upper or lower or mixed case. Se
asap-utilities.com. It sure saves me a bunch of time every day.

D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set all caps as the default? 10
All CAPS to Caps 2
How do I apply the formula =PROPER(text) to existing text in works 1
Using VLOOKUP results in a DSUM criteria range 2
Change from mixed caps and upper lower to all upper lower case 3
Validate data but then change the entry to upper case 4
How to set Auto-Change letters into Uppercases for Data entry in E 3
Caps Lock vs Lower Case 5

Top