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.
- It will open the Macro dialog box.
- Then, select the Hide_Titlebar option from the Macro name section.
- After that, click on Run.
- As a result, we will get the full screen with no title bar. See the screenshot.
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.
- From the Ribbon Display Options, select Auto-hide Ribbon.
- As a result, it will show the full screen with no title bar. See the screenshot.
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.
- 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.
- As a result, it will show the full screen with no title bar. See the screenshot.
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.