Hi,

I suspect you had an addin in Excel 2003 that allowed you to do that because
it's not standard functionality. Maybe you could add the addin in to 2007.

Mike

"SimpleIsBest" wrote:

In Excel 2003 I could select one or more cells, then right click and select
'Change Case' and then choose to make the text in them all either 'UPPER
CASE', 'Proper Case' or 'lower case' as I wished.
Unless I have overlooked it, that option seems to have disappeared in Excel
2007. The only entries I can find in the Help system relate to using
functions, but I just want a simple menu option.... Any ideas?