When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Dick

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Dick

Right click on the bar at the bottom of the styles tab and select
"customize the ribbon".

In that, you select "main tabs" and then "home" and "styles", and then
select the commands you want added.

If the color boxes are there in that list, they will then appear when
you check them.

On Sun, 24 Feb 2013 06:08:26 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Dick

Right click on the bar at the bottom of the styles tab and select
"customize the ribbon".

In that, you select "main tabs" and then "home" and "styles", and then
select the commands you want added.

If the color boxes are there in that list, they will then appear when
you check them.

Just found your problem.

The new package (2010) AND 2013 AUTO-Sizes the ribbon.

So, IF you maximize the window, it will likely re-appear.
I found this as my 2013 install also has your dialogs missing.

UNTILL I stretched the window across my screen ad they started popping
into their old familiar places.

So stretch your window or maximize it. Removing ribbon elements you do
not use much also leaves those elements you do often use remaining.

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't

Expand your Excel window back to full size.

Excel doesn't want you to have to scroll the ribbon horizontally, so
when the window isn't wide enough it collapses some of the ribbon
icons into groups.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Upon further investigation, I found a note that says the formatted
style boxes show if the window is wide enough.

Given that I haven't done anything to the window width, where did they
go? Other than maximizing the window, is there any way to increase
width?

On Sun, 24 Feb 2013 09:22:40 -0500, wrote:

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Upon further investigation, I found a note that says the formatted
style boxes show if the window is wide enough.

Given that I haven't done anything to the window width, where did they
go?

Apparently, there are more ribbon elements than in the previous
version.

Other than maximizing the window, is there any way to increase
width?

I think you can shuffle the element positions. Turning OFF those
elements you do not use helps as well. They refer to it as
"customization".

You remove commands you do not use. That parses the ribbon elements
down, and yours are more likely to be visible again.

On Sun, 24 Feb 2013 06:08:26 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't
changed anything.

Dick

Right click on the bar at the bottom of the styles tab and select
"customize the ribbon".

In that, you select "main tabs" and then "home" and "styles", and then
select the commands you want added.

If the color boxes are there in that list, they will then appear when
you check them.

That's not the problem. The colored tabs used to appera by default now
they don't. I didin't add anything that oulwd have made them go away.
Yesterday they were there, today they are not.

I did fiddle with some desktop properties (icon size, spacing, label
size). Does that have any effect on applications?

On Sun, 24 Feb 2013 06:21:31 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:


Just found your problem.

The new package (2010) AND 2013 AUTO-Sizes the ribbon.

So, IF you maximize the window, it will likely re-appear.
I found this as my 2013 install also has your dialogs missing.


UNTILL I stretched the window across my screen ad they started popping
into their old familiar places.

So stretch your window or maximize it.

It's already maziimized.

Removing ribbon elements you do
not use much also leaves those elements you do often use remaining.

I shouldn't have to remove anything as the cell styles were displayed
with all the elements currently on the ribbon.

On Sun, 24 Feb 2013 09:22:17 -0500, Stan Brown
wrote:

On Sun, 24 Feb 2013 08:52:09 -0500, wrote:

When I installed Excel 2010, I found Home Styles Cell style
presented me with default cell colors for four types of cells: Normal,
Good, Bad, Neutral.

Today that color display has disappeared, collapsed into the Styles
button. If I expand the button I can see the missing display. How can
I get it back on the ribbon? To the best of my knowledge, I haven't

Expand your Excel window back to full size.


The window is already maximized.

On Sun, 24 Feb 2013 06:36:02 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:


Given that I haven't done anything to the window width, where did they
go?

Apparently, there are more ribbon elements than in the previous
version.

There is no previous version involved. I've been using 2010 for months
and the cell styles have been displayed. I didn't upgrade anything.


I think you can shuffle the element positions. Turning OFF those
elements you do not use helps as well. They refer to it as
"customization".

You remove commands you do not use. That parses the ribbon elements
down, and yours are more likely to be visible again.

As I said earleir, the cell styles have been displayed with the ribbon
elements as they are. The styles literally disappeared overnight.

On Sun, 24 Feb 2013 09:49:04 -0500, wrote:


That's not the problem. The colored tabs used to appera by default now
they don't. I didin't add anything that oulwd have made them go away.
Yesterday they were there, today they are not.

I did fiddle with some desktop properties (icon size, spacing, label
size). Does that have any effect on applications?

Apparently it does. I had set the font size to Large expecting it to
only affect the desktop labels but apparently it affects Microsoft
apps as well.

The built-in in the Home menu of Excel went missing for me.
I could not find them to add back in.
I eventually got there...
Right click on ribbon [Customize the ribbon...]
In right most box under the words "Customize the Ribbon (i)"
The drop down box read "Main Tabs"
Below it in the tree view for "Main Tabs" I left clicked on "Home"
Having done that I clicked on the "Reset \/" button below
Then I selected "Reset only selected Ribbon Tab"
Then I clicked "OK"
I could now see the "Built-in Styles" of Bad;Good;Neutral;Calculation etc.

You can also remove some items you rarely use in order to provide more real estate for the Styles menu.