There may be times when you want to see as much of your worksheet as possible. You can quickly maximize your worksheet to replace virtually everything else on your screen by displaying the View tab of the ribbon and clicking the Full Screen tool in the Workbook Views group.
When you are done working with Excel in this manner, click on the on-screen button to restore the regular view, or simply press the Esc key.
In Excel 2013 the Full Screen tool was removed, so the above technique won’t work. Instead, follow these steps:
- Display the View tab of the ribbon.
- In the Show group, uncheck all the check boxes. (You may only be able to uncheck three of them or you may be able to uncheck all four. In either case, uncheck all that you can.)
- At the upper-right corner of the program window, click the Ribbon Display Options icon and choose Auto-Hide Ribbon. Excel immediately makes the ribbon disappear. (See Figure 1.)
- Maximize Excel’s program window.
Figure 1. Accessing the Ribbon Display Options.
When you are done viewing the workbook in this manner, again use the Ribbon Display Options icon to display the ribbon and, on the View tab of the ribbon, select the check boxes you unchecked in step 2.