How to Exit Full Screen in Excel (3 Easy Methods)

For better readability of data and visibility in Excel, we often enter full-screen mode. But after the job is done, we need to exit the full-screen mode to save the work. We do not often find the exit full-screen option. If you also have the same question- How to exit full screen in Excel, the article will show you exactly the methods and steps.

How to Exit Full Screen in Excel (3 Easy Methods)

There are 2 most common methods to exit full screen in Excel. One is using Excel built-in options and the other one is applying keyboard shortcuts. These two methods are applicable for most common uses. But if we are working on a large VBA content, we may need to enter full-screen mode and later need to exit it. We can also exit the full screen using the VBA code as well. So we will see all 3 methods below.

1. Use of Context Menu to Exit Full Screen

Excel provides us with built-in options to exit full-screen mode. To do so, we follow these two steps.


  • First, we need to right-click anywhere on the workbook. A panel of different options will appear.
  • Second, we need to select Close Full Screen. This will exit the full-screen mode.

Use of Context Menu to Exit Full Screen

2. Applying Keyboard Shortcuts

We can apply keyboard shortcuts to exit full-screen mode in Excel as well. It is useful while typing fast. To exit full screen We can simply press the Esc button. If you are in the process of inserting data, you may need to press the Esc button twice to do so.

3. Using VBA Code

While we are working on large-scale calculations, there may be some phases where we need to go full screen and then return to it to show visual differences. Usually, VBA is used to do such large-scale calculations. So here we will learn the steps to exit full-screen mode with VBA in Excel.


  • Firstly we will press Alt+F11 to open Microsoft Visual Basic for Application. We can do the same by selecting Developer from the ribbon and then clicking on Visual Basic.

Easy Methods to Exit Full Screen in Excel

  • Secondly, we will select Insert and then select Module in that window. A tab will appear where we will write our visual basic code.

  • Thirdly we will copy-paste the following code in the tab. Here we have also given the code for entering the full screen for better understanding.
Sub Exit_Full_Screen()
Application.DisplayFullScreen = False
End Sub
Sub Enter_Full_Screen()
Application.DisplayFullScreen = True
End Sub

Easy Methods to Exit Full Screen in Excel

  • Furthermore, we will press Ctrl+S to save the code. We need to save the file as an Excel Macro-Enabled Workbook (*xlsm).
  • After pressing Ctrl+S a dialog box will appear confirming that we want to save as the expected file format. We will save it as an XLSX file and save it.

  • Next, we will press Alt+F8 to trigger the Macro We can also do it by choosing Macros from the Developer tab in the ribbon.
  • Finally, we will select Exit_Full_Screen and press Run. This will exit the full-screen mode.

Easy Methods to Exit Full Screen in Excel

How to Enter Full-Screen Mode in Excel

We can enter full-screen mode using two methods. The methods are below:

  1. We have to press Alt+V to enable view mode. Then just press ‘U’ to enter full screen mode.
  2. In our VBA method, we also included the function Enter_Full_Screen to activate the full-screen mode. We can run the function as well.

How to Enter Full Screen Mode in Excel

Things to Remember

  • The VBA method is applicable when we are doing large calculations with VBA.
  • The demonstration of this article was done in Excel 365. So the interface might vary for other versions.

Download Practice Workbook

You can download the practice workbook from here.


The article showed how to exit and enter full-screen mode in Excel using different techniques. If you’re still having trouble with any of these methods, let us know in the comments. Our team is ready to answer all of your questions.

Related Articles

<<Go Back to Excel Full Screen | Excel Worksheets | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nasir Muhammad Munim
Nasir Muhammad Munim

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF