Keystroke to Text Bar

J

John Gregory

Task: Given a column of text, I want to edit all and capitalize the first
letter of each entry.
Problem: I have to use my mouse to insert the cursor in the task box for
each successive cell I move to. Isn't there a keystroke to take me to that
text box?
 
L

L. Howard Kittle

Hi John,

I don't know of a key stroke but perhaps you can use =PROPER(A1) and pull
down. Then copy > paste special > values back into your column.

HTH
Regards,
Howard
 
Top