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.
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
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.