+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Keyboard shortcut for changing font color?

  1. #1
    Registered User
    Join Date
    07-25-2009
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    Keyboard shortcut for changing font color?

    Hello!
    I have a question regarding shortcuts changing the font color of parts of words. I've attached an image in case my question is not clear.

    I like to Bold (CTRL+B) and change the font color of only parts of words. For example: dogs -> dogs

    I can do CTRL+B easily enough, but I was wondering if it were possible to find a way to do the same for the font color? Right now, I have to highlight the letters, then move my mouse all the way to the top left corner and click... it's a pain. Even better, is it possible to make a command that would let me bold and change the color at the same time?

    I'd be happy just being able to move the Font color button closer to where I need them, but it seems stuck on the ribbon and I can't move it.

    I tried to record a macro, but it would only work for an entire cell - I can't figure out how to make it work for just highlighted characters. I'm also pretty shaky with Excel, so I don't understand a lot of the coding jargon or advanced stuff.

    Thanks for any help!
    Attached Images Attached Images

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Keyboard shortcut for changing font color?

    Unfortunately, there is no shortcut for changing font color.

    However, you can move the font color toolbar. Click the drop down arrow on the toolbar and hover your mouse just under the top edge of the toolbar, then click and drag to position it where desired. This works for the fill and borders tool bars as well.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Keyboard shortcut for changing font color?

    That image is of the ribbon so no ***-off toolbars.

    You can press CTRL+1 whilst editing the cell to display the Font dialog.

    Also if you are editing in the formula bar rather than directly in the cell the Font group is relatively close and active.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Keyboard shortcut for changing font color?

    That image is of the ribbon so no ***-off toolbars.
    Thanks for catch Andy. I didn't look at the image, just looked the OP's Excel version listed in his profile, which is 2003.

  5. #5
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Keyboard shortcut for changing font color?

    ***-off toolbars.
    now what did that say? that got censored lol
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,480

    Re: Keyboard shortcut for changing font color?

    I typed "ripoff toolbars" but it didn't like the hyphen, how strange.

+ 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