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.
- 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.
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.
- 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.
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.
- 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. See the screenshot.
Read More: [Fixed!] Excel Spreadsheet Opening Larger Than Screen
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.
You do realise this doesn’t work – even your screen shots showing “no title bar” still has the title bar right at the top.
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.