Application.DisplayFullScreen = True
this puts it into the old school full screen size Tie it to a button that floats if you want it everywhere as an option for presentations especially.
This article compares two ways of getting full screen mode in Excel, which can be helpful for you to expand the work area flexibly.
The full screen mode of Excel will hide the ribbon, status bar, and the formula bar.
In Excel 2007/2010, Click on the View tab and click Full Screen in the Workbook View group. See screenshot:
In Excel 2013, click on the View tab and uncheck all types in the Show group to make the screen full. See screenshot:
The third party add-in Kutools for Excel can help get 4 options to maximize the Excel work area. The options appear as a floating bar in the upper right space of the window. The Options are as follow:
After installing Kutools for Excel, you can quickly switch to full screen view by applying Work Area.
Please apply the utility by clicking Kutools > View > Work Area. See screenshots:
As soon as clicking Work Area, Excel will be switched to the full screen view which hides formula bar, status bar and ribbon, see screenshot:
Note: you also can click the last icon to switch to this type of screen view.
In addition to this type of screen view, you also can switch to other two types of screen view by applying Work Area of Kutools for Excel.
Click the second icon to hide status bar，see screenshot:
Click the third icon to hide status bar and formula bar, see screenshot:
If you want to stop or exit this utility, just click the first icon in the Work Area Size, it will return to the normal view.
More detail information about Work Area, go to Work Area Size.
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
200 New Features for Excel, Make Excel Much Easy and Powerful: