- #CUSTOMIZE THE RIBBON IN EXCEL FOR MAC 2017 HOW TO#
- #CUSTOMIZE THE RIBBON IN EXCEL FOR MAC 2017 FREE#
We prefer the Arrange section on the left to access the selection pane and other object tools.
#CUSTOMIZE THE RIBBON IN EXCEL FOR MAC 2017 FREE#
Themes are good but in day to day work you may use the Page Layout or Arrange sections a lot more.įeel free to rearrange the sections to work for you. Microsoft loves pushing themes because they are simple and look great in demonstrations. In Excel 2016,the Page Layout tab has ‘Themes’ in the prime position.
Redmond wants to promote a particular feature, especially in it’s demonstrations. Sometimes, Microsoft puts a button in the prime, left position because it suits the company’s interests. If you look at the edited Home tab above you’ll see that the Editing group has been squeezed while the Paragraph and Clipboard groups to the left have not been reduced. Mind you, the choices Office makes for compressing a ribbon aren’t consistent. If you put your preferred items on the left, they should continue to appear even in a narrower window.
The Office ribbon adjusts automatically to the width available with the group on the right generally being compressed first. So, it makes sense to put your most commonly used buttons on the left as well. That’s why the ‘File’ menu is at top left as is the Quick Access Toolbar. (not sure if this applies when the native language is ‘right to left’). Why does it matter?įor most Office users, our eyes automatically search from left to right when looking for a button or menu. Personally, we liked the friendlier name ‘Chunks’, but that was changed to the more boring ‘groups’. In the early days of the ribbon, the name for the collection of buttons on the ribbon wasn’t fixed. Note: unlike the Quick Access Toolbar, changing the ribbon does NOT affect keyboard shortcuts. Here’s how that looks on the Customize list. Font then Styles, Editing, Paragraph and finally, Clipboard. Here’s a revised Home tab with our preferred groups first on the left side. Sometimes the buttons are useful, especially the Paste Special options.Ĭlick on the Clipboard item and then the down arrow to move it along the ribbon. That’s OK because we want to move the Clipboard part, not remove it entirely. You can’t remove the Clipboard group from the Home tab because it’s one of the in-built tabs. Under the Home tab you can see the groups, Clipboard, Font, Paragraph, Styles and Editing. On the right-side is a list of the current tabs and the groups available on each row. It’s far more likely they’ll use the keyboard shortcuts (eg Ctrl + C, Ctrl + X or Ctrl + V).Ĭhanging that is easy, right-click on the ribbon and choose ‘Customize the Ribbon …’ Most people don’t use the ribbon to copy, cut or paste except in special cases. Microsoft’s analysis over the years confirms that, but does it mean it should be in the prime, left position? Microsoft puts the most commonly used features or the most important (to Microsoft) in that left position.Ĭopy, Cut and Paste are certainly the most commonly used functions in Word.
The left side is the most prominent place for any ribbon button or section. The very left of the Home tab has the Paste and other clipboard related features. The QAT is certainly easier to change but a single line of buttons isn’t always enough. Even so Microsoft’s usual advice is to change the Quick Access Toolbar.
#CUSTOMIZE THE RIBBON IN EXCEL FOR MAC 2017 HOW TO#
Then how to change it to suit you.Ĭhanging the ribbon was difficult in Office 2007 but improved in later versions. In this article, we’ll show you an example of how the ribbon is designed to suit absolute Office novices first and also with Microsoft’s marketing agenda in mind. You’re not stuck with the ribbon Microsoft gives you, make it work better for you. Love or loath it, the ribbon in Microsoft Office is here to stay. Thanks for joining us! You'll get a welcome message in a few moments.
0 kommentar(er)
