Results 1 to 9 of 9

Fill-color keyboard shortcut

This is a discussion on Fill-color keyboard shortcut within the Excel Questions forums, part of the Question Forums category; Is there keyboard shortcut for fill color?...

  1. #1
    Board Regular
    Join Date
    Apr 2003
    Posts
    70

    Default Fill-color keyboard shortcut

    Is there keyboard shortcut for fill color?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,132

    Default Re: Fill-color keyboard shortcut

    Hi jiggawhat

    Iím not so sure of a joint keystroke to fill a cell will colour, but it is possible to do this with a combination of key presses if that any help for you


    Kindest possible regards
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,132

    Default Re: Fill-color keyboard shortcut

    Try this combination

    Press ALT+SHIFT+P, this is the short cut to font size
    Press TAB a few times to get across to the font fill icon
    Press arrow down

    - You see the colour box drop down?

    Now press arrow down / right

    Select the colour you want to fill the cell with

    Press enter

    Your done, a bit long winded but knocks out the use of a mouse if that was your aim, but sorry not so much a short cut, but is just as fast I assure you.


    Hope that helps you a bit or offers an alternative

    Kindest possible regards
    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    New Member
    Join Date
    Jan 2010
    Posts
    7

    Default Re: Fill-color keyboard shortcut

    Hi anybody can help because i could not find my color fill palette in excel 2003

  5. #5
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    7,737

    Default Re: Fill-color keyboard shortcut

    Maybe,

    CTRL-1, to bring up Format cells dialog

    then either CTRL-TAB or CTRL-SHIFT-TAB as required until the 'Patterns' tab is active

    ALT-C

    arrow to the colour you want, SPACE to select it

    TAB two times to activate the OK, then RETURN to complete

    And, btw, after you've done one, F4 can be used to repeat

    HTH, Fazza

  6. #6
    New Member
    Join Date
    Jan 2010
    Posts
    7

    Default Re: Fill-color keyboard shortcut

    Thanks a lot. how can i put the color fill in the tool bars menu?

  7. #7
    MrExcel MVP
    Join Date
    May 2006
    Location
    Excel 2003, Australia
    Posts
    7,737

    Default Re: Fill-color keyboard shortcut

    please refer to Excel help

    it leads me to http://office.microsoft.com/training...RC010036361033

  8. #8
    New Member
    Join Date
    Mar 2010
    Location
    California
    Posts
    10

    Default Re: Fill-color keyboard shortcut

    I've developed a simple add-in that allows you to create custom keyboard shortcuts to apply font and fill colors to the selected cells. It also retains the undo history.

    Keyboard Shortcuts to Change Font & Fill Color or Cell Style | Excel Campus

  9. #9
    New Member
    Join Date
    Mar 2014
    Posts
    3

    Default Re: Fill-color keyboard shortcut

    Keyboard Shortcut to Fill Color in a Cell automatically in Excel 2007

    Step 1 - Involves selecting the color you want

    Press Alt-H-H
    Use Arrow Keys to choose the color
    Press Enter to select the color

    Step 2 - Automatic Fill
    Press F4

    Enjoy

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com