I want to try conditional formatting for a cell, but can't find it where it apparently should be: in the Styles group in the Home tab.
I have no Styles group! (Just Clipboard, Font, Alignment, Number, Cells and Editing) I suspect I may have removed it when first I installed Office 2010.
I've tried "Customise the Ribbon" and tried to add Conditional Formatting, but it tries to put this into a new group, whereas I want it back where it was originally!
Any ideas, please?! I can't find anything about this from Googling. Thanks
Excel 2010: return Style(s) group to Home tab of ribbon
-
- PlatinumLounger
- Posts: 5437
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Excel 2010: return Style(s) group to Home tab of ribbon
John Gray
If you are having problems with solitude, you are not alone.
If you are having problems with solitude, you are not alone.
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Excel 2010: return Style(s) group to Home tab of ribbon
Try adding the whole styles tab:
File - options
Customize ribbon
Choose: All tabs
Home
select Styles
[Add>>]
I see no way to remove just cond formatting (it is grayed out) but it looks like (I did not want to try it, however) removing the whole Styles tab...
Steve
File - options
Customize ribbon
Choose: All tabs
Home
select Styles
[Add>>]
I see no way to remove just cond formatting (it is grayed out) but it looks like (I did not want to try it, however) removing the whole Styles tab...
Steve
-
- Administrator
- Posts: 78788
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel 2010: return Style(s) group to Home tab of ribbon
In Customize Ribbon, make sure that the Home tab is selected in the list on the right hand side.
Select "Main Tabs" from the "Choose commands from" dropdown on the left hand side.
Expand Home.
Select Styles.
Click Add >>.
If necessary, move the Styles group in the right hand list up or down.
Select "Main Tabs" from the "Choose commands from" dropdown on the left hand side.
Expand Home.
Select Styles.
Click Add >>.
If necessary, move the Styles group in the right hand list up or down.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 5437
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Excel 2010: return Style(s) group to Home tab of ribbon
Thanks, chaps - it was a matter of choosing 'Main tabs' in the left-hand window!
John Gray
If you are having problems with solitude, you are not alone.
If you are having problems with solitude, you are not alone.