Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 2007

Kathryn has attended:
Excel Introduction course
Excel Intermediate course

Excel

how can you change words from capitals to lower case in a spreadsheet?

RE: excel

Hello Kathryn,

To change from Lower to capital case in Excel, use the function word Lower(). There is no ChangeCase option from the Ribbon bar that Word 2007 has.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

RE: excel

Hi Kathryn, this link http://www.theexceladdict.com/_t/t031112.htm
explains the process Mark says about above, it also has some more Excel help.

Baz

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.