Microsoft Office Tutorials and References
In Depth Information
Showing and Hiding Workbook Elements
Did You Know?
You can search for a value or data in a cell, and then replace it with
different content. Click the cell or cells containing content you want to
replace. Click the Home tab, click the Find & Select button, click Re-
place, specify the values or data you want to find and replace, and then
click the appropriate Find or Replace buttons.
You can no longer use the Split box control. The Split box control
( New ! ) on the worksheet window has been removed in Excel 2013.
Showing and Hiding Workbook Elements
When you open a new or existing workbook, Excel displays a standard set of elements,
such as the Formula Bar, Headings (columns and rows), Gridlines, and Ruler, which is
available in Page Layout view. If you need a little more display room to see your data or
you want to see how your data looks without the gridlines, you can quickly select or clear
view settings on the Data tab in Excel to show or hide these elements.
Show or Hide Workbook Elements
Click the View tab.
Select or clear the check box for the element you want to show or hide.
Ruler . In Page Layout view, the horizontal and vertical rulers.
Gridlines . The gray outline around cells.
Formula Bar . The bar below the Ribbon.
Headings . The column (letters) and row (numbers) headings.
Search JabSto ::




Custom Search