For example, you can select one Total row cell, then choose Select Similar Cells to select them all. Select similar cells in a pivot table: Click a cell, Control-click, then choose Select Similar Cells.

Select nonadjacent cells: Click a cell, then Command-click any other cells. If you do this accidentally, drag the yellow dot back to its original position, or press Command-Z on the keyboard to undo the action. If you drag the yellow dot, you copy the cell contents to the rows you drag over. Select a range of adjacent cells: Click a cell, then drag a white dot any direction across the range of adjacent cells.

Select a cell to add or edit its content: Double-click it.

Restore an earlier version of a spreadsheet.Save a large spreadsheet as a package file.See the latest activity in a shared spreadsheet.Place objects inside a text box or shape.Format Chinese, Japanese, or Korean text.Use a keyboard shortcut to apply a style.Create, rename, or delete paragraph styles.Bold, italic, underline, and strikethrough.Format a spreadsheet for another language.Select text and place the insertion point.Change the look of chart text and labels.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Calculate values using data in table cells.Quickly calculate a sum, average, and more.View the source data for a pivot table value.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Use VoiceOver to create formulas and autofill cells.Intro to images, charts, and other objects.

Cant select cell office mac 2017