Hello geniuses \\\/// Find computer shortcut keys that may decrease ur work load. regrds Sen!!!!!!!!!
From Oman
Acknowledge(0)
Amend(0)
4From Oman
Acknowledge(0)Amend(0)
Dear All, Can you tell me how can i change Capital letter to small letter in excel. if you have any shortcut key pls provide me.
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Dear Mohsinsen, Thanks a lot for the post, was really looking for this kind of chart. Its a useful piece of information. Best Regards, Jervin Christopher
From India, Madras
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
a person doing the job from last eight years in pvt. ltd. he is eligible for gratuity? if employer refuse for the gratuity what is the rights to recive the gratuity .
From India, Jaipur
Acknowledge(0)Amend(0)
From India, Jaipur
Acknowledge(0)Amend(0)
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!!!!!!!
From Oman
Acknowledge(0)Amend(0)
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!!!!!!!
From Oman
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)
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
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Microsoft Excel Shortcut Keys[1].pdf