+ Reply to Thread
Results 1 to 8 of 8

keyboard shortcut to convert small case to uppercase

  1. #1
    Registered User
    Join Date
    11-19-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    81

    keyboard shortcut to convert small case to uppercase

    hiya! Is there any keyboard shortcut to convert small case to upper case in excel 2007

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: keyboard shortcut to convert small case to uppercase

    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

  3. #3
    Registered User
    Join Date
    11-19-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: keyboard shortcut to convert small case to uppercase

    there was a keyboard shortcut...i used to use it earlier...not sure of it now...can anyone pls let me know

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: keyboard shortcut to convert small case to uppercase

    take a look at this site, maybe you can find something there...
    http://shortcutworld.com/en/win/Excel_2007.html

  5. #5
    Forum Contributor
    Join Date
    07-03-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    109
    Kutools is perfect for this. Nice little add on I think. And its free for a trial period.

  6. #6
    Registered User
    Join Date
    11-19-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    81

    Re: keyboard shortcut to convert small case to uppercase

    Hi! I could not find a keyboard shortcut. Can you suggest me a macro for this??

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: keyboard shortcut to convert small case to uppercase

    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

  8. #8
    Registered User
    Join Date
    02-10-2013
    Location
    PR
    MS-Off Ver
    Excel 2003
    Posts
    93

    Re: keyboard shortcut to convert small case to uppercase

    Quote Originally Posted by FDibbins View Post
    =upper() copied where you need it will convert lower case to upper case....
    Does the opposite exist? Upper case to lower case? How do I make the call to that function?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1