+ Reply to Thread
Results 1 to 5 of 5

capital letters

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    union city
    MS-Off Ver
    Excel 2010
    Posts
    3

    capital letters

    I wont to use all captial letters in my spread sheet is there a font or way to do this.

  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,938

    Re: capital letters

    use =upper()
    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
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: capital letters

    The button above the Shift key on your keyboard - CAPS LOCK - should do the trick.

    - Moo

  4. #4
    Forum Contributor
    Join Date
    09-23-2008
    Location
    Mexico
    Posts
    200

    Re: capital letters

    You need fonts like these:
    http://www.fonts101.com/search/small+cap

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: capital letters

    Microsoft Word has a font setting for "all caps" so that even if you type lowercase letters, they are displayed as caps. However, Excel does not have this formatting option. This is different than "small caps" fonts as referenced above. Maybe there is an "all caps" font but I can't find one. One way around this would be to use a macro to convert cells to all caps every time you type; crude but effective.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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