Cell Basics
Editing a Cell
To edit the content of a cell, double-tap the cell and enter desired information.
Entering Data into a Cell
After double-tapping into a cell, a keyboard will open which provides
several options for data entry type. It defaults to the numeric keyboard,
but is easily switched.
Numerical Data: The first time this keyboard is opened, you may
type numbers in with no formatting. However, there are several
other formatting options. You can choose the “$” to automatically
format the data into currency style. The “%” option, formats the
entries into percentages. The “******” button allows you to enter
a star rating. The “checkbox” option puts a checkbox in the field.
Date & Time: This keyboard looks like a calendar. You have options to change date, time and duration.
Text/Alphanumeric Data: This keyboard looks like the standard
keyboard on your iPad. You can enter numbers using this keyboard, but this is mainly used for text.
Formulas: This is the keyboard where the traditional spreadsheet formulas can be entered. Clicking on the “functions” button
on this keyboard will give you the familiar list of options. In addition, to return to the other keyboards, tap the “...” button next to
the “=”.
Filling a Row or Column with Data
In the row or column you want to fill, enter the data
into the first cell of the row (or column). Tap “Done”
to close the keyboard. Tap the cell again. Then tap
“Fill”. You will see a yellow box around the cell.
Drag the appropriate edge as needed to fill the
empty cells. It is defaulted to fill with the “next item
in a series” (ex: 1,2,3 or a,b, c) if the text keyboard
is used (even with numbers).
Rows and Columns
Selecting a Row or Column
To select a row or column, click once in any cell. Tap the gray bar
next to the row or column you wish to select. The column or row then
becomes highlighted in blue. Once a row or column is selected, you
can use the blue handles to expand your selection.
Adding or Removing Columns or Rows
To add a column, tap and hold the button icon above the table. Drag
to the right until you have the desired number of columns. To delete a
column, select the column and choose “Delete” from the floating
menu.
To add a row, tap and hold the button icon to the left of the table.
Drag down until you have the desired number of rows. To delete a
row, select the row and choose “Delete” from the floating menu.
32