How to Show Full Screen with No Title Bar in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working with a large dataset, you need to show the Excel in full screen with no title bar. In Microsoft Excel, you can do this quite easily and effectively. In this article, we will show how to show Excel full screen with no title bar. I hope you find this article quite informative and gain lots of knowledge regarding this topic.


How to Show Full Screen with No Title Bar in Excel (3 Suitable Methods)

To show Excel full screen with no title bar, we have shown three different methods through which you can effectively do the work. All of these methods are fairly easy to use. Moreover, we use a VBA code to show the Excel full screen with no title bar. The other two commands consist of two Excel commands.


1. Using Ribbon Display Options

The best and simplest method to show full screen with no title bar is by using the Ribbon Display Options. In this method, we will use the Ribbon Display Options at the top and display the Excel full screen with no title bar. To understand this method properly, follow the steps.

Steps:

  • First, select the Ribbon Display Options.

Excel Full Screen No Title Bar

  • From the Ribbon Display Options, select Auto-hide Ribbon.

Excel Full Screen No Title Bar

  • As a result, it will show the full screen with no title bar. See the screenshot.

Excel Full Screen No Title Bar

Note: You can execute the task using the keyboard shortcut: CTRL + SHIFT + F1

2. Embedding VBA Code

Microsoft Visual Basic for Applications (VBA) is Microsoft’s event-driven programming language. Using this VBA code, you can show the Excel full screen with no title bar. While solving several problems, VBA code can give a better platform. To use it, you need to display the Developer tab on the ribbon.

Steps:

  • First, go to the Developer tab on the ribbon.
  • Then, select Visual Basic from the Code group.

  • It will open up the Visual Basic window.
  • Then, go to the Insert tab in this window.
  • From there, select the Module option.

  • Then, write down the following code in the Module window.
Sub Hide_Titlebar()
Application.DisplayFullScreen = True
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
  • After that, close the window.
  • Then, go to the Developer tab on the ribbon again.
  • From the Code group, select the Macros option.

Excel Full Screen No Title Bar

  • It will open the Macro dialog box.
  • Then, select the Hide_Titlebar option from the Macro name section.
  • After that, click on Run.

Excel Full Screen No Title Bar

  • As a result, we will get the full screen.

Excel Full Screen No Title Bar


3. Customizing Ribbon to Show Full Screen

In this method, we will customize the ribbon and enable the full-screen commands. Using this full-screen command, we will get the full-screen. To apply this method, follow the steps carefully.

Steps:

  • First, right-click on the ribbon.
  • From there, select Customize the Ribbon.

  • As a result, it will open the Excel Options dialog box.
  • Then, right-click on the View tab and select Add New Group.
  • You can’t add new commands on the ribbon without adding a new group or tab,

  • Because of this, you will a new group below the Macros option.
  • Now, you can add a new command.

  • Then, select All Commands from the drop-down option in the Choose commands from section.

  • After that, scroll down and find out the Full-Screen command.
  • Then, select the Full-Screen command and click on Add.

Excel Full Screen No Title Bar

  • As a result, it will add to the newly created group. See the screenshot.
  • Finally, click on OK to apply the change.

  • Then, go to the View tab on the ribbon.
  • After that, from the New Group, select Full Screen.

Excel Full Screen No Title Bar

  • As a result, it will show the full screen. See the screenshot.

Excel Full Screen No Title Bar

Read More: [Fixed!] Excel Spreadsheet Opening Larger Than Screen

Note: When you use macro code or customize ribbon, you will get the application in full-screen mode but there will be the title at the left top corner of the application.

Things to Remember

  • We can’t get the Full-Screen command in your Excel by default. We need to customize the ribbon and get the Full Screen command.
  • When you click on the Restore Down option, Excel will go back to its default format.

Download Practice Workbook

Download the practice workbook below.


Conclusion

We have shown three different methods to show Excel full screen with no title bar. These three methods are fairly easy to use. In these three methods, we use a VBA code, ribbon display options, and customizing ribbon. Some of the methods are not as suitable compared to others but depending on the situation you can utilize what you prefer. If you have any questions, feel free to ask in the comment box.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul
Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

2 Comments
  1. You do realise this doesn’t work – even your screen shots showing “no title bar” still has the title bar right at the top.

    • Reply Avatar photo
      Naimul Hasan Arif Mar 1, 2023 at 5:14 PM

      Dear JEFF,
      Thanks for your comment. Here, the first method not only makes Excel full-screen but also hides the title bar along with tabs and ribbons.

      The other methods also make Excel full-screen along with hiding tabs and ribbons but can’t manage to hide the title bar.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo