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

Keyboard Shortcut to add/delete rows or columns in Excel

Shortcut to Copy the contents of the cell above or on the left

Alternative for SUMIF and SUMIFS