Highlight all the text you want to change, then right click and from the options choose "Font" left click and from the window that appears, place a tick in the box, "ALL CAPS". Do the same to reverse the procedure. When finished just remove the tick from the box. j.
Sorry, I did a quick check from "word" and the Font option is in there from a right click, after highlighting. I thought that it may be the same with excel, but it isn't. I would think there is a way to do it though, just need to wait for one of the excel experts to come on-line. j.