Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Enable Full Screen in Excel? 3 Simple Ways

How to Enable Full Screen in Excel? 3 Simple Ways

(Note: This guide on how to enable full screen in Excel is suitable for all Excel versions including Office 365)

Have you ever felt that when watching a movie or while surfing the internet, the full-screen mode gives you a more immersive experience? Yes, full-screen mode is effective with almost every application ranging from entertainment to professional purposes. It enhances the way we look at data and improves user interaction. 

Did you know that you can expand the screen size in Excel for a better experience of the application? In this article, I will tell you how to enable full screen in Excel in 3 simple ways.

You’ll Learn:

  • Why Switch to Full-Screen Mode in Excel?
  • How to Enable Full Screen in Excel?
    • Using the Ribbon Display Options
    • Using the Shortcut Keys
    • Using the Quick Access Toolbar

Related Reads:

How to Wrap Text in Excel? With 6 Simple Methods

How to Enable Excel Dark Mode? 2 Easy Methods

How to Create an Excel Slicer? 2 Easy Ways

Why Switch to Full-Screen Mode in Excel?

If you are probably wondering why you would want to switch to full-screen mode, there’s probably more than one reason. In addition to giving you a full-screen user experience, Excel offers you some additional features:

  • Enabling full screen in Excel hides the ribbons and the options tray. However, if you feel like there is a need for ribbons, you can enable and disable them anytime you like.
  • Enabling the full-screen mode makes more space for rows and columns to be visible. In the Normal mode, you’d have 28 rows compared to the 37 rows in full-screen mode.
  • For some applications, when you’re using them in full-screen mode, the application becomes view only, or you cannot use the program or some of its features. Whereas in Excel, you can use the application as you use it in the normal mode. 

How to Enable Full Screen in Excel?

Initially, there was an easy option to enable full screen in Excel with just the click of a button. You’d just have to navigate to View and in the Workbook Views section, click on the Full Screen. And if you wanted to exit the full screen, right-click anywhere on the screen and click on Close Full Screen.

But, this option is not available in Excel 2013 and the following versions like Excel 2016, Excel 2019, Excel 2021, and Office365.

However, there are a couple of additional ways and methods you can use to enable the full screen in Excel in the newer versions.

Using the Ribbon Display Options

This is one way to enable full screen in Excel. When using this method, you don’t have to navigate to any specific ribbon or tabs.

  • Click on the dropdown from Ribbon Display Options in the right corner of the ribbons tab.
  • Click on Full-screen Mode.
How to enable full screen in Excel using Ribbon Display options
How to enable full screen in Excel using Ribbon Display options
  • This immediately hides the ribbons and additional buttons on the Excel window leaving only the worksheets tab visible. 
Full screen mode in Excel
Full screen mode in Excel
  • To disable the full-screen mode and return to the normal mode, click on the ellipsis button in the top-right corner of the window near the close button.
Disable full screen mode
Disable full screen mode
  • This in turn enables the ribbons and the options tray.
  • Again, click on the dropdown from Ribbon Display Options and click on Always show Ribbon.
  • This reverts the Excel window to its normal mode. 
Select Always Show Ribbon
Select Always Show Ribbon

Note: You can see the taskbar appearing even when the full-screen mode is enabled. This is because the taskbar is a feature of the operating system and not an Excel function. If you want to hide the taskbar too, go to Taskbar Settings and check the checkbox for the Automatically Hide the Taskbar option.

Also Read:

How to Hide and Unhide Columns in Excel? (3 Easy Steps)

How to Stop Excel From Rounding? 4 Easy Ways

How to Freeze Rows in Excel? 4 Easy Steps

Using the Shortcut Keys

This is by far the easiest way to toggle between full-screen mode and normal mode in Excel. You can use the shortcut keys to enable full screen mode while using any operation or function.

  • To enable the full screen in Excel, hold the Ctrl key and press the Shift + F1 altogether i.e. press the keys Ctrl+Shift+F1.
Enable Full Screen in Excel using Shortcut keys
Enable Full Screen in Excel using Shortcut keys
  • If you want to return to the normal mode, press the same keys (Ctrl+Shift+F1) you used to enable the full-screen mode.

Using the Quick Access Toolbar

The Quick Access Toolbar offers a variety of options to perform a variety of functions all with just a click of a button. If you are a person who is comfortable working in full-screen mode and a mouse, then adding the full-screen button to the Quick Access Toolbar might be a better option.

  • First, check if you have the Quick Access Toolbar enabled. If you cannot see the Quick Access Toolbar, click on the dropdown from Ribbon Display Options. From the dropdown, select Show Quick Access Toolbar.
How to enable full screen in Excel using Quick Access toolbar
How to enable full screen in Excel using Quick Access toolbar
  • Once you can see the Quick Access Toolbar, click on the Customize Quick Access Toolbar option. Click on More Commands.
Click on More Commands
Click on More Commands
  • This opens the Excel Options dialog box. From the Choose commands from dropdown, select All Commands.
  • Scroll down until you see the Full Screen option.
  • Select it and click on Add.
  • Click OK.
Select Full screen and click Add
Select Full screen and click Add
  • This adds the Full Screen button in the Quick Access Toolbar.
Select Full Screen from Quick Access Toolbar
Select Full Screen from Quick Access Toolbar
  • If you want to enable the full-screen mode, just click on the Full Screen button in the Quick Access Toolbar.
Full Screen in Excel
Full Screen in Excel
  • If you want to exit the full-screen mode and revert to the normal mode, just press the Esc key. 

Suggested Reads:

How to Remove Spaces in Excel? 3 Easy Methods

How to Convert Text to Numbers in Excel? 5 Easy Methods

How to Insert Bullet Points in Excel? 5 Easy Methods

Frequently Asked Questions

How do I exit a full screen in Excel?

To exit a full screen in Excel, try pressing the Esc key or use the same method you used to enable the full screen mode.

Why can’t I find the full screen option in Excel 2016 or Office365?

The option to enable full screen mode in Excel was only available in versions prior to Excel 2013. In Excel 2016 and later versions, you can only use the ribbon display option, shortcut keys, or by adding the full screen option to the Quick Access Toolbar.

If I close my Excel window, will it restore to normal mode?

If you enable the full screen mode in Excel, you can exit by pressing the Esc key. If it doesn’t work, you can save the file and hard quit by pressing the close button. If you open Excel, it opens in Normal mode.

Closing Thoughts

Full screen in Excel is a very helpful feature that greatly enhances the user experience. Once you start using Excel in full screen mode, you might fall in love with the experience.

In this article, we saw how to enable full screen in Excel in 3 easy ways. Depending on your preferences you can choose the method that suits you the best. 

If you need more high-quality Excel guides, please check out our free Excel resources center. Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Using Org Chart Themes, Layouts, and Arrangement in Visio 2010

How to Use the TEXTJOIN Excel Function? 3 Easy Examples

How to Hide Formula Bar in Excel (and Show)? 3 Easy Ways

Using Templates in Microsoft Access 2019

Creating a Company File in QuickBooks Pro 2013

Microsoft Project 2019: Subtasks and Outlining

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)