Fill-color keyboard shortcut

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

Jack in the UK

Well-known Member
Joined
Feb 16, 2002
Messages
3,215
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
 

Dlareg

New Member
Joined
Jan 4, 2010
Messages
7
Hi anybody can help because i could not find my color fill palette in excel 2003
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,328
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
 

Dlareg

New Member
Joined
Jan 4, 2010
Messages
7
Thanks a lot. how can i put the color fill in the tool bars menu?
 

iamraajkanchan

New Member
Joined
Mar 6, 2014
Messages
3
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
 

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,568
Members
405,408
Latest member
Bravomb96

This Week's Hot Topics

Top