You cant start analyzing, poking, and prodding data on your iPad until you enter the numbers.

They also show how to delete, copy, and move data on a worksheet.

Each cell can hold text, a data value, a logical value (True or False), a formula, or nothing at all.

Meanwhile, the keyboard appears, as do the Letters button and the Numbers button so that you can switch between a lettered keyboard and a numbered keyboard.

To enter text for example, to enter a descriptive data label tap the Letters button, if necessary.

As well as tapping the Return key to enter data, you can tap an arrow key.

Tapping an arrow key makes the cell above, the cell below, the cell to the left, or the cell to the right the active cell.

To enter serial data, start by selecting the first two items in the series.

For example, to enter the days of the week, enter Monday in one cell and Tuesday in the next, and select both cells.

Then drag a green arrow on the selected cell range to fill out the rest of the serial data.

Then drag a selection handle to encompass all the cells you want to select.

Then tap in the Formula bar where the data needs editing and edit to your hearts content.

Marquee lights appear around the data to show that it can be moved or copied.

Select the cells where you want to move or copy the data and choose Paste on the popover menu.

Click this button and choose an option from the dropdown list to keep the cells formatting, paste values only, or paste formulas.

At this point, you can select more than one column or row by dragging a green selection handle.

For example, to insert a column between what are now columns E and F, select column F.

You can insert more than one column by selecting more than one.

Excel inserts as many columns as the number you select before the Insert operation.

For example, to insert a row above what is now row 8, select row 8.

Select row(s) and column(s), click the Insert Delete Cells button, and choose an Insert or Delete option on the dropdown menu.

Excel For Mac Enter Cell