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??
Published with Blogger-droid v1.6.7


  1. Thanks Arvind Post some more..... Sayan


Post a Comment

Popular posts from this blog

Alternative for SUMIF and SUMIFS

Solving issues with "VLOOKUP"

Excel Keyboard Shortcuts - Handy during day to day work