Share via

Excel: shortcut for applying fill color directly

Anonymous
2019-11-03T11:28:32+00:00

Dear community,

is it possible to directly apply the color shown on "fill cell" icon to a cell (orange in the screenshot below)? I like to navigate with the Alt-shortcuts and selecting orange over and over again from the large selection of colors (screenshot 2) takes a lot of time with the arrow keys.

Thank you for your help!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-11-03T11:34:06+00:00

    HI!

    This is Ruchi, an independent expert.

    Follow the link, it will help you out:

    https://excel.officetuts.net/en/examples/highli...

    Do let me know, if you have any query.

    Regards

    Ruchi

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2019-11-03T11:52:03+00:00

    Is there a way to use the color shown on the icon apart from using F4 if color a cell was not the last action?

    10 people found this answer helpful.
    0 comments
  3. Anonymous
    2019-11-03T12:22:49+00:00

    Hi

    I just read the article, (very good, clear and to the point, by the way), I learned from it.

    My answer to you.

    According to the article, the method you should use is creating your own shortcut with macro.

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2019-11-03T12:33:55+00:00

    Can sb help me to write this macro? Thank you!

    0 comments
  5. Anonymous
    2019-11-03T13:53:02+00:00

    Through conditional formatting, you can do this. For this you have to define the data.

    0 comments