Search

View tab in Sheets

 

View tab in Sheets Windows

The View dropdown houses spreadsheet navigation controls alongside display options.

Go to Cell... – Go to a specific cell by entering its coordinates, rather than to it.
Zoom... – Lets you change your view to a predefined or custom zoom level.
Freeze – Locks the display of cells and columns so that they will always display on-screen. The lock area starts at the row-column intersection of the currently selected cell.
Gridlines – Toggles the display of gridlines (or cell borders) for individual sheets.
Headings – Toggles the display of row letters and column numbers across the top and left side of the Sheets Editor.
Right-to-Left Sheet – Create a Right-to-Left sheet.

 

View tab in Sheets Android

The View tab houses spreadsheet navigation controls alongside find and selection options.

Go to Cell – Useful for large spreadsheets, this field allows you to go directly to a specific cell by entering in its coordinates (ColumnLetter:RowNumber).
Zoom – Lets you change your view to a predefined zoom level.
Zoom to Normal – Returns the zoom level to default.
Freeze – Allows you to lock the display of cells and columns so that they will always display on-screen. The lock area starts at the row-column intersection of the currently selected cell.
Cell Content – Displays a popup of the current cell contents, including values and formulas. For cell ranges, only the upper leftmost cell content will be displayed.
Hide Gridlines – Toggles the display of gridlines (or cell borders) for individual sheets..
Sheets – Displays a popup of all the sheets in the spreadsheet, and allows you to navigate between them.
Charts – Displays all of the charts in the document, and can open them individually in full screen mode for easier viewing.
Start/Stop Selection – Toggles selection mode that allows you to select multiple cells, starting with the currently selected one.
Select All – Selects all of the cells in the spreadsheet that contain data.

 

View tab in Sheets iOS

The View tab houses spreadsheet navigation controls alongside find and selection options.

Zoom – Lets you change your view to a predefined zoom level.
Go to Cell – Useful for large spreadsheets, this field allows you to go directly to a specific cell by entering in its coordinates (ColumnLetter:RowNumber).
Freeze – Allows you to lock the display of cells and columns so that they will always display on-screen. The lock area starts at the row-column intersection of the currently selected cell.
Cell Content – Displays a popup of the current cell contents, including values and formulas. For cell ranges, only the upper leftmost cell content will be displayed.
Show Gridlines – Toggles the display of gridlines (or cell borders).
Show Headings – Toggles the display of headings (the vertical bar displaying the row number and the horizontal one displaying the column letter).
Right-to-Left Sheet – Create a Right-to-Left sheet. Very helpful when inserting data in RTL languages such as Hebrew, Arabic or Farsi.
Start Selection – Toggles selection mode that allows you to select multiple cells, starting with the first one.
Select All – Selects all of the cells in the spreadsheet that contain data.
Find & Replace – Searches for instances of text entered in the Search field, and will replace them with text entered in the Replace field. Browsing between search results is done with the Back and Forth arrows. The  Gear icon provides options to:
 
  • Match Case – Will search for exact cases such as capitalized or all lowercase letters.
  • Match Entire Cell – Will filter out results that have the searched text as a part of a larger cell entry.
  • Look in – Will search either through cell values or cell formulas.