Changing a whole worksheet/spreadsheet to uppercase

[KLT]

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]

Check out 'index to 485 Excel Articles' at the bottom of the page.
Loads of great stuff there.

Colin.

 

[KLT]

Thanks. You're right lots of stuff there.