Changing a whole worksheet/spreadsheet to uppercase

KLT

New Member
Joined
Mar 21, 2005
Messages
36
Hi all,

Is there a way to adapt the UPPER command or any other command to format the text on the whole spreadsheet to uppercase. Or do I have to use VBA coding to do this?

I've used the UPPER for one column at a time but I don't think this is an efficient way of doing things.

Any ideas would be appreciated?

KLT.
 

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
Check out 'index to 485 Excel Articles' at the bottom of the page.
Loads of great stuff there.

Colin.
 

Forum statistics

Threads
1,078,404
Messages
5,340,020
Members
399,348
Latest member
duel

Some videos you may like

This Week's Hot Topics

Top