When you double-tap a cell, a keyboard appears. The input bar above the keyboard is where you type. Buttons in the input bar allow you to switch between keyboards to enter the type of data you want: numbers, text, currency, percentages, dates and times, durations denoting a span of time (for example, “3 weeks 4 days 2 hours”), formulas and functions, checkboxes, and star ratings.
Note: If you can’t add content to a table, make sure it’s unlocked. Select the table, tap 
, tap Arrange, then tap Unlock (if you don’t see Unlock, the table isn’t locked).
Double-tap the cell, then tap the keyboard symbol for the type of data you want to enter:
Numerical data: Tap 
, then type values. You can add data in more specific formats by first tapping a symbol on the keyboard:
Currency: 
.
Percentage: 
.
Star ratings: 
. Slide your finger along the dots in the input bar to indicate the number of stars you want.
Checkboxes: 
. To mark the checkbox as selected, tap the checkbox in the input bar so that it reads “true,” or tap the checkbox in the table.
Date and time: Tap 
, then tap Date & Time. Tap a token in the input bar, then tap the value for it on the keyboard.
Duration: Tap , then tap Duration. Tap a token in the input bar, then tap the value for it on the keyboard.
Alphanumeric data (text): Tap 
. To include digits or punctuation, tap 
. To return to the alphabetic keyboard, tap 
.
Move to another cell by tapping 
or 
in the keyboard, or by tapping another cell in the table or Next on the keyboard if you’re entering text.
Tap Done to dismiss the keyboard.
For information about keyboard layouts, see Keyboard for entering numerical values, Keyboards for entering time-related data, Keyboards for entering text, and Keyboards for entering formulas and functions.
Select the cells.
Tap Delete.
A systematic and quick way to enter data into a large table, row-by-row, is to display the table as a form. With a form, you can edit all the data within a single table row at once and quickly move between rows. Forms can speed up your workflow, for example, if you’re entering similar data on a large sample population and you want to move quickly between individual records.
You can use forms for entering data in a table only if the table includes a header row and doesn’t include any merged cells. A header column is optional.
Create a table with a header column listing the record names (optional), and a header row listing the data categories you want to enter in each record.
Tap 
in the upper-left corner of the sheet, then tap New Form.
If your spreadsheet includes several tables, a list of tables appears.
Tap the name of the table for which you want to create a form.
In the form that appears, tap a field in the right column to edit it.
Tap Next in the keyboard to move to the next field in the form, or scroll the form to see all the fields, and tap the one you want to edit.
If you can’t place the insertion point in a field, it means that field contains the result of a calculation and can’t be edited from the form.
Tap 
to go to the next record in the table, or tap 
to return to the previous record.
To jump between nonconsecutive records, tap a dot along the right side of the screen.
Tap 
to add a new record or tap 
to delete the current record.
Tap another tab to exit the form.
You can quickly fill cells, or a row or column, with the same data or a logical sequence of data—for example, a series of numbers, letters, or dates.
Do any of the following:
Autofill one or more cells with content from adjacent cells: Select the cells with the content you want to copy, tap Fill, then drag to extend the yellow cell border over the cells where you want to add the content.
Any data, cell format, formula, cell border, or fill associated with the selected cells is added, but comments aren’t. Autofilling overwrites existing data with the value you’re adding.
Autofill cells with sequential content or patterns from adjacent cells: Type the first two items of the series in the first two body cells of the row or column you want to fill; for example, type A and B. Select the cells, tap Fill, then drag the handles over the cells you want to fill.
You can also autofill cells using a pattern of values. For example, if two selected cells contain 1 and 4, the values 7 and 10 are added when you drag over the adjacent two cells (values are incremented by 3).
Autofilling doesn’t establish an ongoing relationship among cells in the group. After autofilling, you can change the cells independently of each other.
When you autofill cells, any formulas that refer to those cells are updated automatically to use the new value.