hiya! Is there any keyboard shortcut to convert small case to upper case in excel 2007
hiya! Is there any keyboard shortcut to convert small case to upper case in excel 2007
not sure about a short-cut, but =upper() copied where you need it will convert lower case to upper case. If needed, you can then copy/paste values over the original data
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
there was a keyboard shortcut...i used to use it earlier...not sure of it now...can anyone pls let me know
take a look at this site, maybe you can find something there...
http://shortcutworld.com/en/win/Excel_2007.html
Kutools is perfect for this. Nice little add on I think. And its free for a trial period.
Hi! I could not find a keyboard shortcut. Can you suggest me a macro for this??
Describe how many cells needs to be converted from lower to uppercase?
what is the range?
range is constant or changeable?
if it is changeable then how to identify the range?
Based on selected range?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks