Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to switch to full screen in Excel ?

This article compares two ways of getting full screen mode in Excel, which can be helpful for you to expand the work area flexibly.


arrow blue right bubble Full Screen Mode in Excel

The full screen mode of Excel will hide the ribbon, status bar, and the formula bar.

In Excel 2007/2010, Click on the View tab and click Full Screen in the Workbook View group. See screenshot:


In Excel 2013, click on the View tab and uncheck all types in the Show group to make the screen full. See screenshot:


arrow blue right bubble Switch to full screen and other two types of screen view with Kutools for Excel

The third party add-in Kutools for Excel can help get 4 options to maximize the Excel work area. The options appear as a floating bar in the upper right space of the window. The Options are as follow:

Kutools for Excel: with more than 120 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

After installing Kutools for Excel, you can quickly switch to full screen view by applying Work Area.

Please apply the utility by clicking Kutools > View > Work Area. See screenshots:


As soon as clicking Work Area, Excel will be switched to the full screen view which hides formula bar, status bar and ribbon, see screenshot:


Note: you also can click the last icon doc-full-screen6 to switch to this type of screen view.

In addition to this type of screen view, you also can switch to other two types of screen view by applying Work Area of Kutools for Excel.

Click the second icon to hide status bar,see screenshot:


Click the third icon to hide status bar and formula bar, see screenshot:


If you want to stop or exit this utility, just click the first icon in the Work Area Size, it will return to the normal view.

More detail information about Work Area, go to Work Area Size.

Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Ray Bawania · 2 years ago
    Alternatively, you could use the following code:

    Application.DisplayFullScreen = True

    this puts it into the old school full screen size Tie it to a button that floats if you want it everywhere as an option for presentations especially.
  • To post as a guest, your comment is unpublished.
    Holly · 2 years ago
    another way to show full screen. Go to File>Options> All commands> Add a new group to the left hand side options, then scroll down in the list on the right to Full Screen. Click add (with your group hi-lighted on the left).

    I didn't like how the 2013 options above still left the top row of options on the screen when I was presenting. This method removes those. To exit full Screen simply click Exit.
  • To post as a guest, your comment is unpublished.
    Mark1234534 · 4 years ago
    Office 2013 also has an option to hide the ribbon itself, which isn't mentioned here, there is a new icon in the right hand corner of the window next to the minimize/maximize/close buttons in the title bar for the window
    • To post as a guest, your comment is unpublished.
      marwerno · 3 years ago
      This was always possible. Office 2013 now just has made an icon for it.
      Try double clicking on the tabs of the ribbon and watch in collapse :-)
      I know it also works in Office 2010, presumably even in Office 2007.