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.


Download Practice Workbook

You can download the practice workbook from here.


3 Easy Methods to Exit Full Screen in Excel

There are two 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 three 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.

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 back 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.

Steps:

  • 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 given the code of entering full screen as well 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 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.

Conclusion

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. For any excel related problems, you can visit our website Exceldemy for all types of excel related problem solutions.

Nasir Muhammad Munim

Nasir Muhammad Munim

I am Nasir Muhammad Munim from Dhaka, Bangladesh. I work as an Excel and VBA Content Developer for Exceldemy right now. Electrical and electronic engineering was my major at Islamic University of Technology, where I got my degree. I love creative works and learning new things. And I'm really into online games, especially first-person shooter games.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo