how to drag down Fill Color selector in Excel 2007?

  • Thread starter Thread starter mj
  • Start date Start date
M

mj

can't get the Fill Color window to stay open as in earlier versions of Excel;
great nuisance to have to open it each time I need to color cells
 
Don't get it.

In EXCEL 2007 Home / Font group / Fill Color is part of the Ribbon so easily
available without needing to re-open it each time.
 
You have to click on the control in the ribbon to redisplay the palette,
because it closes every time you use it.

In earlier versions you could actually drag the palette off the toolbar
and place it next to where you were working.

This change was one of the "enhancements" that the 2007 UI astronauts
imposed on us. Impediments is more like it, because it contributes to
the overall productivity decline among Excel 2007 users.

- Jon
 
Solution: just create a few simple macro's in your PERSONAL.XLSB like this:

Sub CellGreen()
Selection.Interior.ColorIndex = 43
End Sub

Sub CellYellow()
Selection.Interior.ColorIndex = 44
End Sub

Sub CellOrange()
Selection.Interior.ColorIndex = 46
End Sub

Sub CellRed()
Selection.Interior.ColorIndex = 3
End Sub

then link them in your Quick Access Toolbar to the colored icons available

Regards,

Robert Ilbrink
 
Back
Top