When the ribbon appeared in Office 2007, we were suddenly flooded with many commands in Excel, we didn’t even know existed. 9 Years later and we still don’t use many of them – I know. Today I’ll show you many more I bet you didn’t know was there.

Day: 165 of 365, 200 left
Tools: Microsoft Office Excel
Description: Hidden Treasures in Excel – Commands not in the ribbon

In a previous post I showed you how to customize your office ribbon. Around the Office in 365 Days: Day 8 – Customizing the Office Ribbon. To use any of these commands I’ll show you today, you will have to customize your ribbon to add them and use them. Follow the steps in the above post to do so.

How to find these hidden treasures:

  1. Click on File
  2. Options
  3. Customize ribbon
  4. Expand Choose commands dropdown
  5. Here you will see “Commands Not in the Ribbon”

Note:  you have to add these to a custom Tab / Group to be able to use it.


There is close to 300 commands there, which does not appear on the ribbon in Excel. Yup – I know – this has taken the crazy to a whole new level!! I urge you to go through the list – and try some of the one’s you don’t know. That’s how we learn.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.