You can also copy rows and columns from a table in another spreadsheet, or from Pages or Keynote. Use this feature if you would like a title row (or rows) to print at the top of every page of your data in Excel. Insert multiple rows or columns within the table: Select a number of rows or columns-equal to the number you want to insert and adjacent to where you want to insert them-tap or, then tap a placement option.ĭelete a row or column within the table: Select the row or column, then tap Delete in the shortcut menu. 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.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.Add a legend, gridlines, and other markings.Add column, bar, line, area, pie, donut, and radar charts.Functions that accept conditions and wildcards as arguments.String operator and wildcards in formulas.Quickly calculate a sum, average, and more.Change how pivot table data is sorted, grouped, and more.Add calculations to summarize group data.Add checkboxes and other controls to cells.Intro to images, charts, and other objects.