Viewing Data in Spreadsheets

Hiding Rows and Columns

Rather than deleting a column or row that may be needed at a later date, you can hide them from the current view using the Hide Rows and Columns feature.

To hide a row or column:

1
Click the header for the column or row to select the entire column or row. You can select consecutive columns or rows by holding Shift and clicking additional headers.
2
From the Edit toolbar, click Hide.
3
Select Hide Columns or Hide Rows from the dropdown.

image alt text

To unhide, click the toolbar icon again and choose Show.

Freezing Columns or Rows

Freeze locks one or more columns or rows in place while the rest of the Spreadsheet is free to scroll. This feature is especially useful when working with large spreadsheets so you can scroll horizontally or vertically to compare data in different columns or rows.

To freeze a row or column:

1
Select the column or row you want to freeze. Freezing a column locks the selected column and all columns to the left of the selection, while Freezing a row locks the selected row and all rows above the selected row.
2
From the View toolbar, click Freeze . Click the icon again to unfreeze the selection.

image alt text

Merging Cells

To merge cells in a spreadsheet:

1
Select the cells you want you to merge.
2
Right-click the selection and select Merge Cells from the dropdown.
3
Select how you want to merge the cells. You can choose to merge cells horizontally or vertically, merge them all together into one larger cell, or unmerge them.

image alt text

Viewing Overlays

You can view locked cells, value formatting, or how numbers are entered and shown using the Overlays feature in the View toolbar. To turn on an overlay:

1
From the View toolbar, click Overlay to open the Overlay Legend in the right panel.
2
Click the arrow to open the dropdown menu. You can select the type of overlay you want to view, as well as see a legend for the selected view.

image alt text

You can temporarily hide an overlay by holding the Alt key on your keyboard. Pressing Alt + ~ toggles an overlay on or off.