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

"Bootsy" wrote:

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?
--
bootsy