Nasir Muhammad Munim
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.
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.
- 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
- 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.
Read More: Excel VBA: Show Userform in Full Screen (4 Easy Ways)
How to Enter Full Screen Mode in Excel
We can enter full screen mode using Two methods. The methods are below:
- We have to press Alt+V to enable view mode. Then just press ‘U’ to enter full screen mode.
- In our VBA method, we also included the function Enter_Full_Screen to activate full screen mode. We can run the function as well.
Read More: How Do I Stop Excel from Opening in Full Screen (4 Ways)
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.
