MS Office | The alternative way to remove the mini toolbar from Word, Excel or PowerPoint

• To disable the Mini Toolbar in Excel, select File from the menu and choose More, then Options.
• In General under the heading User Interface Options, locate and remove the tick next to Show Mini Toolbar on selection.
• When you click OK, the Mini Tool bar should no longer appear.

Note: In the video we make reference to removing the Mini Toolbar in Excel. However we noticed that in our instance of Excel, the mini toolbar would not switch off. So in order to disable the Mini Toolbar we had to edit the Registry in Windows.

• Close Excel.
• Click on the Windows Start button.
• Using Search locate and open Registry Editor.
• Drill down the following path in the registry:

HKEY_Current_User > Software > Microsoft > Office > 16.0 > Common > Toolbars > Excel

• Now in the main panel, right click your mouse and from the quick menu choose, New – DWORD (32-bit Value)
• Give the new Registry Key the name AllowMenuFloaties.
• Make sure the key has a value of 0.

Note: Deleting the AllowMenuFloaties key or changing its value to 1. Will turn the Mini Toolbar back on. You can also disable the Mini Toolbar in PowerPoint and Word by putting a AllowMenuFloaties key in the corresponding registry Toolbars folder for those applications.

• Close Registry editor and open Excel.
• You should find that the Mini Toolbar no longer appear.

• Mydoodads article – 5 useful ways to customise Microsoft Word.
• Mydoodads article – How to turn off the Startup screen in MS Excel.
• Mydoodads article – MS Excel | Customise your instance of Excel.

• Microsoft article – Customise the ribbon in Office.
• Microsoft article – Customise how Excel starts.
• Microsoft article – Customise the Quick Access Toolbar.