The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon again, you will enter the code "application.executeExcel4macro''show.toolbar(""Ribbon"", true)''" Then save it as a macro enabled workbook. Alt + F8 (open all macros) will be necessary to apply the changes to the ribbon.
Home
Microsoft Office How to Completely hide the Ribbon menu in Excel

By rawhy
Apr 21, 2010 10:42 PM
You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.
Sign up for Gadget Hacks Weekly and start unlocking your phone's full potential.
Comments
Be the first, drop a comment!