New workbooks contain a default set of elements: Ruler, Gridlines, Message Bar, Formula Bar, Column Headings and Row Headings. Excel allows you to display or hide these items by checking or clearing the box next to the item. This feature can come in handy if you need extra room for formatting or wish to see how your spreadsheet will look without gridlines.
To Display or Hide Workbook Elements
- Click the View tab on the Ribbon.
- Click or clear the check box for the element you wish to display or hide on the Show/Hide group.