Each time when Excel is launched, the program opens a new workbook whose sheets use a whole bunch of standard display settings. The standard settings consist of :
- 3 blank worksheets each identified by their own sheet tabs.
- 256 columns in each sheet, labeled with a column header using letters A through IV.
- 65,536 rows in each sheet, labeled with a row header 1 through 65536.
- Gridlines demarcating the edge of each sheet’s
- columns and rows and thereby displaying the outline of each worksheet cell.
Sometimes you need to max out the worksheet display so that you access as many cells and as much of your spreadsheet data as possible, thus saving you from having to waste a lot of time scrolling up and down and back and forth to view the cells you need to work with.
The fastest and simplest way to remove the screen clutter caused by the Excel toolbars and thereby maximize the number of cells displayed on your screen is by switching to Full Screen view: View -> Full Screen. In full screen mode, Excel temporarily hides any open toolbars, gets rid of the Formula bar at the top and the sheet tabs, the horizontal scroll bar, and the program’s Status bar at the bottom, leaving only the Worksheet menu bar, column and row headers, vertical scroll bar, and Windows taskbar surrounding the blank worksheet cells.
In Full Screen view, a floating Full Screen toolbar will be placed in the lower-right corner of the screen. To switch back into normal screen view, simply click the toolbar’s Close Full Screen button. Excel closes the Full Screen toolbar and restores all the missing toolbars.
Full screen view in Excel is best for entering scads of spreadsheet data or checking up on your data entries. However, if you need to have the Formula bar displayed on the screen follow these steps:
- Choose Tool -> Options.
- Select the View tab in the Options dialog box.
- Select the Formula Bar check box and then click OK to close the Options dialog box.
After displaying the Formula bar when the program is in Full Screen view, Microsoft Excel will remember your setting and it continues to appear on the screen as you switch in and out of Full Screen view. If you decide that you don’t need the Formula bar on the screen in Full Screen view, deselect the Formula Bar check box in Step 3 of the preceding steps.