Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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.


Download Practice Workbook

Download the practice workbook below.


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

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 through which we can show the Excel full screen with no title bar. The other two commands consist of two Excel commands.


1. 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 have 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 with no title bar. See the screenshot.

Excel Full Screen No Title Bar

Read More: Excel VBA: Show Userform in Full Screen (4 Easy Ways)


2. Using Ribbon Display Options

Our second method is based on 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


3. Customizing Ribbon to Show Full Screen with No Title Bar

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 with no title bar. 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 from 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 with no title bar. See the screenshot.

Excel Full Screen No Title Bar

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


Things to Remember

  • By default, we can’t get the Full Screen command in your Excel. 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.

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. I think we covered all possible areas regarding this topic. If you have any questions, feel free to ask in the comment box. Don’t forget to visit our Exceldemy page.


Related Articles

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.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo