Adjust Columns or Rows in iPad Numbers App

If you’ve ever used a spreadsheet program, you know that data you enter doesn’t always fit into preset columns and rows. In the iPad Numbers app, you can select the columns or rows you want to work on and then rearrange or resize them.

Especially with spreadsheets that have lots of rows and columns, resizing can be easier using a stylus.

Selecting a row or column

Tap in the row frame to select the corresponding row, as shown in this figure.

image0.jpg

Tap in the column frame to select the corresponding column.

After you select a row or column, you can adjust the selection by dragging the handles (the round buttons) at the top and bottom (or left and right for columns), as shown in this figure.

image1.jpg

The selection buttons Cut, Copy/Paste, Delete, Hide, and Create Chart appear above a selected column, while Cut, Copy, Delete, Fill, or Comment appear above a selected row. Select an object. This figure shows several cells selected within a column.

image2.jpg

The selection button you tap affects the selected column or cell.

For example, use the selection button to merge selected cells in a column (or row).

Resizing a row or column

The two vertical lines (known as the Cells button) in the top-right corner of the column frame and the two horizontal lines in the bottom-left corner of the row frame let you resize the selected columns or rows. You always resize a column to its right and a row to its bottom, whether you’re making it larger or smaller.

The contents are automatically adjusted, and the adjoining rows or columns are moved aside.

Moving a row or column

Sometimes, you want to rearrange the rows or columns in a sheet. With one or more rows or columns selected, press and drag it (or them) to a new position. All selected rows or columns move as a unit, and the other rows or columns move aside.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com