ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to drag down Fill Color selector in Excel 2007? (https://www.excelbanter.com/excel-discussion-misc-queries/244826-how-drag-down-fill-color-selector-excel-2007-a.html)

mj

how to drag down Fill Color selector in Excel 2007?
 
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

trip_to_tokyo[_3_]

how to drag down Fill Color selector in Excel 2007?
 
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.

"mj" wrote:

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


Jon Peltier[_2_]

how to drag down Fill Color selector in Excel 2007?
 
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



trip_to_tokyo wrote:
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.

"mj" wrote:

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



All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com