Insert a row or column within the table: Select an adjacent row or column (tap the row number or column letter), tap or, then tap a placement option. You can delete a row or column only if all of its cells are empty.Ĭhange the number of rows or columns in the table: Select the table, tap, tap Table, then use next to Rows or Columns, or tap the number of rows or columns to enter a new value. Tap in the top-right corner of the table to add one column drag to add or delete multiple columns.

Restore an earlier version of a spreadsheetĪdd or delete a row or column at the edge of the table: Tap in the bottom-left corner of the table to add one row drag down or up to add or delete multiple rows.

See the latest activity in a shared spreadsheet.

Place objects inside a text box or shape.

Format Chinese, Japanese, or Korean text.

Make characters superscript or subscript.

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.

How to add multiple rows in excel cell