How do I change everything in my spreadsheet to all UPPERCASE?

B

Bootsy

I'm just trying to make everything in my spreadsheet the same case. Is there
an easy way to do this, like there is in Word?
 
G

galimi

Go into VBE and enter the following all in one line

for each sht in this workbook.sheets:for each cl in
sht.usedrange.cells:cl.value=ucase(cl.value):next:next

replace ucase with lcase if you desire lowercase

http://HelpExcel.com
 
G

galimi

Remove the space I accidentally embedded between the word this and workbook...

It should read thisworkbook
 
Top