Lower case to upper case help !

  [DELETED] 16:05 27 Oct 2003
Locked

I have an excel document where I ave done everything in lower case and I want to change the entire document so that all the fonts are in upper case, does anyone know how I do this ?

Office 2k.

Thanks a million !

L

  [DELETED] 16:08 27 Oct 2003

By highlighting the text & pressing the shift key [up arrow] & F3 or F$ would do thi, but I don't have O2k.

Worth a try though?

Regards,

Paul

  [DELETED] 16:16 27 Oct 2003

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.

  [DELETED] 16:22 27 Oct 2003

Djohn

When I right click, I dont get the 'font' option....


I get cut copy paste, insert delete clear comments, format cells pick from list an hyperlink


??

  [DELETED] 16:34 27 Oct 2003

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.

  [DELETED] 16:38 27 Oct 2003

Found this in excel, hope it is of help. j.

Case Adjustments
SHIFT F3 will change the case of the selected word. Press it repeatedly to cycle through upper case, lower case, and title case.

  [DELETED] 16:43 27 Oct 2003

Looks like I got one right?!

  [DELETED] 16:46 27 Oct 2003

I noticed after I had posted that it was the same answer as yours. Makes a change for me to get it right. ;o)

  [DELETED] 16:54 27 Oct 2003

I am sort of there but it just seems to change one box rather than them all. I will keep at it though.

Thanks plsndrs3 and Djohn.

L.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best computer security tips

Best of the Grad Shows 2018: Central Saint Martins (CSM) illustration and graphic design

Best Mac monitors & displays 2018

Sécurité : comment protéger votre iPhone contre les pirates informatiques ?