How do I delete functions from the ribbon?

somanyqs

Board Regular
Joined
Oct 2, 2007
Messages
76
This one is driving me batty...
I am using Office for Mac 2011.
I would like to, for some of the tabs (ie Home, Layout, Tables, etc.) in the ribbon, change some of the functions that are visible - or even rearrange the order.
For example, as it is currently for the Home tab in the ribbon, when I open it to a smaller-sized screen, some functions are dropped first (like to select a border style from a drop-drown), but others remain that I never use, like the ones in the "Themes" or "Cells" section. Is there a way to remove specific functions, or even entire "sections" like Themes or Cells?

I can't do this (I think....) through the setting menu that lets me choose:
Ribbon Preferences (this only lets me hide entire Tabs)
or
Customize Ribbon Order

I'm sure this is simple - just not sure how to do it!
Thanks!!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
I have limited experience with Office 2011 (and macs in general), but in Excel 2010 it's a simple as right-clicking on the ribbon and selecting the "Customize Ribbon..." option. However, you can remove entire groups, but not individual buttons.
 
Upvote 0
Gotcha - sounds like not possible to remove just one (or a few) buttons from within the ribbon (it does make it a pain when the window is so small some of the buttons I often use are hidden...nuts). Thank you!
 
Upvote 0

Forum statistics

Threads
1,214,979
Messages
6,122,551
Members
449,088
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top