I need to change the case of an entire spreadsheet in excel. Is this possible and if so how?

Answer 1

Not in Excel. Excel is for spreadsheets, Word is for word processing, however, there is a way to "beat the system."

click on the "table select" button (to the left of A, above #1).
This should select and highlight the whole table.

Just to be safe, I suggest you copy.
Go to a new Word document and paste.
It will be a Word table.
Select the columns containing the text in which you want to change case and click Format, Change Case.

When finished, again to be safe, save the file to something like temp.
Control+A to select all
Copy
go to a new Excel worksheet and paste.

If you are a confident user, you could have cut and pasted all the way, but I have learned when dealing with a file that took a lot of time to formulate, it doesn't hurt to copy and paste to be safe. When all is well, just delete the unwanted stuff.

Answer 2

Yeah, do a "select all" and go to Format>Font> and select "all caps" from the menu, or uncheck it if you need to go to all lowercase.

Answer 3

make a macro:
http://www.cpearson.com/excel/case.htm
http://support.microsoft.com/kb/291323


i'm not sure what this procedure below will do to formulas
you may want to display them using CTRL+` or just not select them.
CTRL+A to select all
CTRL+C to copy

open word
CTRL+V to paste
SHIFT+F3 to change case

CTRL+C to copy

go back to excel
CTRL+V to paste

i would paste to a new worksheet just to be sure you don't mess up your data

Answer 4

Can you go to the top left, click the whole sheet blue and then go to format??

Answer 5

"Yeah, do a "select all" and go to Format>Font> and select "all caps" from the menu, or uncheck it if you need to go to all lowercase."

-MadMax08