select text
To select text, do any of the following while viewing a spreadsheet in editing view:
Select a word: Double tap it.
Select a paragraph: Triple tap in the paragraph.
Select an item in a list: Tap its bullet, number or letter.
Select a range of text: Double tap a word, then move the grab points to include more or less text.
Select non-contiguous text: Press and hold the Command key on a connected keyboard while selecting two or more non-adjacent words or ranges of text using a trackpad or mouse.
To deselect a portion of any non-contiguous selections, press and hold the Command key, then select the text you want to exclude.
On iPad, you can also drag two fingers across the keyboard to move the insertion point, then tap once on the keyboard to select a word and twice to select a paragraph.
You can select a range of continuous text or multiple non-contiguous selections only within the same area of a sheet — for example, within a single text box, shape or table cell.
To deselect all text selections, click anywhere on the sheet outside a selection.