Proper case (1st letter of every word in upper case) - shift + ctrl + p
Upper case (all characters in upper case) - shift + ctrl + u
Lower case (all characters in lower case) - shift + ctrl + l
Isn't it handy??
Published with Blogger-droid v1.6.7
This is my "Small World"... a place where I share my views and my know-how!!
Saturday, March 12, 2011
Changing case of text in a cell
Excel 2007 and 2010 versions allow easy shortcut keys to change the case of the text in any given cell.
Proper case (1st letter of every word in upper case) - shift + ctrl + p
Upper case (all characters in upper case) - shift + ctrl + u
Lower case (all characters in lower case) - shift + ctrl + l
Isn't it handy??
Proper case (1st letter of every word in upper case) - shift + ctrl + p
Upper case (all characters in upper case) - shift + ctrl + u
Lower case (all characters in lower case) - shift + ctrl + l
Isn't it handy??
Subscribe to:
Post Comments (Atom)
Thanks Arvind Post some more..... Sayan
ReplyDelete