Try this, Louise (you'll probably want to use the macro solution):
http://www.officearticles.com/excel/...ft_exce l.htm
************
Anne Troy
www.OfficeArticles.com

"Louise" wrote in message
...
What is the easiest way to change the whole of my worksheet to upper case?

urgent help needed!!!

Thank you......

Louise