Hide the Excel Interface and Show Only Data

Add to Favorites
Author:

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.

Result:

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.

Result:

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

Result:

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:

Result:

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.

Result:

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


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course