Discover Computer Shortcut Keys That Can Make Your Workday Easier and More Efficient

Hello geniuses,

Find computer shortcut keys that may decrease your workload.

Regards,

Sen

Dear All,

Can you tell me how I can change capital letters to small letters in Excel? If you have any shortcut key, please provide me.

Dear Mohsinsen,

Thank you very much for the post; I was really looking for this kind of chart. It's a useful piece of information.

Best Regards, Jervin Christopher

A person who has been working in a private limited company for the past eight years may be eligible for gratuity. If the employer refuses to provide the gratuity, what are the rights of the employee to receive it?

Dear Amit Insa,

I will provide some information which may help you.

There are two methods you can use to change existing cell values to upper, lower, or proper case. The first method is to use a formula to change the case. The second method is to use a VBA procedure.

To change the case with a formula, insert a blank column next to the column whose case you wish to change. In that column, enter one of the following formulas, depending on what case you want as the result. Change the reference A1 to the first cell in your range.

=UPPER(A1)

=LOWER(A1)

=PROPER(A1)

Next, fill this formula down in the new column as far as you need to go to convert all your cells. Finally, copy the new column, select the first cell in the original range, A1 in this example, and choose Paste Special from the Edit menu. In that dialog, choose the Values item in the Paste options. You can now delete the column you added. Note that this method should not be used if your original range has formulas in it. The paste operation will overwrite any existing formulas with static text values.

This is how you can change capital letters into small letters.

Regards,

Sen!!!!!!!

Hi Mr. Sen,

Thank you very much for sharing such an important and useful chart with me. I always find myself in a mess as I don't know all these shortcuts. Now, at least I can try to be faster in my work. Please keep on sending me updates. Thanks once again.

Phulora

Hi friends,

Please find attached. You can generate shortcut keys in MS Word using macros; it's very simple.