Hide the Excel Interface and Show Only Data

Add to Favorites

I'm going to show you how to remove almost every interface from Excel and streamline the program so that the data is all people can focus on.

This is the result we want:

Steps to Hide the Excel Interface

Minimize the Ribbon Menu

Right-click any title from the Ribbon Menu and then select the Minimize the Ribbon option, or simply double-click the title.


Remove the Column and Row Headings and the Formula Bar

Go to the View tab and in the Show box un-check the options for Formula Bar and Headings.


Hide the Scroll Bars and Sheet Tabs

Note that this does not delete the sheet tabs or any data on them.

  1. Go to the File menu or the Office button, if you have Excel 2007, then click Options
  2. Go to the Advanced section listed in the menu on the left of the Excel Options window. 
  3. Scroll down to the Display options for this workbook section.
  4. Un-check these options:
    1. Show horizontal scroll bar
    2. Show vertical scroll bar
    3. Show sheet tabs


Remove Items from the Quick Access Toolbar

You may also remove items from the Quick Access Toolbar to further eliminate clutter by clicking the down-facing arrow to the right of the toolbar and de-selecting all options:


Remove Final Elements from the Bottom of the Window

Right-click the bar at the bottom of the window and un-check everything you don't want to show.  Note that some elements only appear when you select cells in the worksheet or perform other actions.


Final Result

Now we have an Excel window that is completely focused on data delivery and nothing else.  The best part about this is that we can get everything back in less than a minute and with just a few clicks of the mouse.

Note: The changes you make to the interface will, for the most part, not be transferred with the Excel file but will, instead, be specific to Excel on your computer.

If you want to go a step further you can use a Macro to remove the status bar and completely remove the Ribbon Menu and completely remove the Quick Access Toolbar.  These tutorials, however, do require the use of VBA code and Macros and are therefore a little more difficult for the average user to understand.

I hope you found this tutorial helpful! :)

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More
Tutorial: How to hide every single part of the Excel interface with the click of a button! This all...
Completely Hide the Ribbon Menu in Excel
Tutorial: Updated Version: Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Sta...
Completely Hide the Quick Access Toolbar in Excel
Tutorial: I'll show you how to completely remove the entire Quick Access Toolbar from Excel. Th...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...
Make Users Enable Macros in Order to View a Workbook in Excel
Tutorial: Tutorial showing you how to make a user enable macros in a workbook in order to view the w...
Pass Arguments to a Macro Called from a Button or Sheet in Excel
Tutorial: How to pass arguments and values to macros called from worksheets, buttons, and anything e...