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

Comments

  1. AnonymousMarch 12, 2011 at 11:27 AM

    Thanks Arvind Post some more..... Sayan

    ReplyDelete

Post a Comment

Popular posts from this blog

Alternative for SUMIF and SUMIFS

Image
Ever wondered while using "SUMIF" function, the sum range cannot be more than one column!!  This indeed is a big drawback while using a large data set where you need to sum matching certain conditions. I often end up using multiple sumif with "+" which makes the formula very long. So was thinking of some alternative that can make life easier. Thanks to the search engines these days, I did come across a workaround. Refer to the above image: In the above example, I have a table with 4 columns where H1 and H2 are identifiers. H3 and H4 is the data which needs to be summed up. Condition 1 (alternative for SUMIF): I need to sum values of H3 and H4 where the identifier H2 is "Y". The formula will be =SUM(IF(B2:B5=B9,C2:D5)) followed by Ctrl + Shift + Enter which will make it a array formula. The final formula will look like this:  {=SUM(IF(B2:B5=B9,C2:D5))} Condition 2  (alternative for SUMIFS) : I need to sum values of H3 and H4 where the
Read more

Solving issues with "VLOOKUP"

Image
VLOOKUP syntax We often encounter "#N/A" while using VLOOKUP function to compare two lists. One of the most common problems that give rise to this error is extra spaces either to the end or to the beginning of the string. What's the way out? The simplest way out is to use "TRIM" function as a sub function. Example While trying to use VLOOKUP in the normal course, the result will be "#N/A", whereas with TRIM nested in the VLOOKUP function will give the positive result. (TRIM function removes the unwanted spaces in the beginning and end of a string.)
Read more

Excel Keyboard Shortcuts - Handy during day to day work

I've had few posts earlier on few excel shortcuts. Navigation powered by "Ctrl" in Excel Shortcut to insert current date in a cell Shortcut to AutoFilter So, here I am, back with some more interesting shortcuts which will make your excel spreadsheet experience simpler. Let me start with some "CTRL" combinations which will be very handy for formating cells to match your requirements: CTRL + 1 : Opens the "Format Cells" dialog box CTRL + 2 : is to make the contents of the cell BOLD (this is a toggle key, to unbold use same CTRL + 2) CTRL + 3 : is to make the contents of the cell ITALICS (this is a toggle key) CTRL + 4 : is to underline the contents of the cell (this is a toggle key) CTRL + 5 : is to strike through the contents of the cell (this is a toggle key) CTRL + 9 : is to hide the entire row (to unhide use SHIFT + CTRL + 9) CTRL + 0 : is the hide the entire column (to unhide use SHIFT + CTRL + 0) CTRL + ~ : is to show or
Read more