How to Exit Full Screen in Excel – 3 Methods

 

 

Method 1 – Using the Context Menu to Exit Full Screen

Steps:

  • Right-click anywhere in the workbook.
  • Select Close Full Screen.

Use of Context Menu to Exit Full Screen


Method 2 – Applying Keyboard Shortcuts

  • Press Esc. If you are entering data, you may need to press Esc twice.

Method 3 – Using a VBA Code

Steps:

  • Press Alt+F11 to open Microsoft Visual Basic for Application. You can also go to the Developer tab and click Visual Basic.

Easy Methods to Exit Full Screen in Excel

  • Select Insert and choose Module.

  • Enter the following code:
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

  • Press Ctrl+S to save the code.
  • Save the file as XLSX.

  • Press Alt+F8 to run the Macro. You can also do it by choosing Macros in the Developer tab.
  • Select Exit_Full_Screen and click Run.

Easy Methods to Exit Full Screen in Excel


How to Enter Full-Screen Mode in Excel

  • Press Alt+V to enable view mode. Press ‘U’ to enter full screen mode.
  • In the previous VBA method, the function Enter_Full_Screen to activate the full-screen mode was included. Run the code.

How to Enter Full Screen Mode in Excel

 


Download Practice Workbook

Download the practice workbook.


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

 

 

ExcelDemy
Logo