U*nexplained ribbon change


I

infodex

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
 
Ad

Advertisements

C

CellShocked

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.
 
C

CellShocked

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.
 
S

Stan Brown

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.
 
I

infodex

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?
 
C

CellShocked

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.
 
Ad

Advertisements

I

infodex

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?
 
I

infodex

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.
 
I

infodex

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.
 
Ad

Advertisements

I

infodex

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top