▶

To select a column, move to the top of the column and click the column reference letter. To select a row, move to the leftmost cell of the row and click the row reference number. Press Esc to cancel the selection.

Handheld: Hold down ▲ to move past the top cell, or hold down ◄ to move past the leftmost cell.

▶

To extend a selection to adjacent rows or columns, hold down Shift and press ◄, ►, ▲ or ▼.

 

1.

Click the row or column that you want to resize.

2.

From the Actions menu, select Resize and then select an option.

3.

Choose a resizing option for a column or row.

-

For a column, choose Resize Column Width, Maximize Column Width or Minimise Column Width.

-

For a row, you can choose Resize Row Height.

The tools that minimise and maximise the column width work automatically. You must manually adjust the size to use the Resize Column Width and Resize Row Height tools.

4.

To resize manually, use ◄ and ► to resize the column, or use ▲ and ▼ to resize the row, and then press Enter.

 

1.

Click a column or row where you want to insert the new data.

2.

From the Insert menu, select either Row or Column.

-

If you are inserting a row, the remaining rows shift down to create space for the new row.

-

If you are inserting a column, the remaining columns shift right to create space.

Note: If other cells contain formulas with relative references to a displaced row or column, those references adjust accordingly.

 

You can delete a row, column, group of rows or group of columns. When you delete a row or column, the remaining rows or columns move up or left to fill the gap.

1.

Click the column or row that you want to delete.

2.

(Optional) To select adjacent rows or columns to delete, hold down Shift and press ◄, ►, ▲ or ▼.

3.

Display the context menu.

-

Windows®: Right-click the selected row.

-

Mac®: Hold the “ key, and click the selected row.

-

Handheld: Press / b.

4.

On the context menu, select Delete Row.

The selected rows or columns are deleted.

Note: If other cells contain formulas that refer to the deleted row or column, those cells show an error. Relative references to cells whose positions have changed because of a deletion adjust accordingly.

 

1.

Click the row number to copy a row, or click the column letter to copy a column.

2.

(Optional) To select adjacent rows or columns to copy, hold down Shift and press ◄, ►, ▲ or ▼.

3.

Copy the row or column:

Windows®: Press Ctrl+C.

Mac®: Press “+C.

Handheld: Press / C.

4.

Move to any cell in the row or column where you want to place the copied items.

5.

Paste the row or column:

Windows®: Press Ctrl+V.

Mac®: Press “+V.

Handheld: Press / V.

The copied row or column is pasted in place, replacing the previous contents.

Note: If you copy a named column, it is pasted with the name removed to prevent a variable conflict.

 

1.

Click the column that you want to move.

2.

From the Actions menu, select Move Column.

An insertion bar appears.

3.

Press ◄ and ► to place the insertion bar at the column’s new position, and then press Enter.

Note: Relative references to any cell in a position is affected by the move adjust accordingly.

 

You can choose to display a column’s calculated results in Exact (fraction) or Approximate (decimal) form. This affects only the values calculated from a formula.

1.

Select the column by clicking the reference letter at the top of the column.

Handheld: Hold down ▲ to move past the top cell.

2.

Display the context menu for the column.

3.

On the context menu, click either Data > Exact or Data > Approximate.

Note: To restore the column results to the document’s default setting, select the column and click Data > Restore Document Setting.

 

The Clear Data command lets you remove the data from selected columns. Clear Data does not delete the column, and it does not clear a column’s name or formula.

After clearing the data, Lists & Spreadsheet recalculates column formulas for the selected columns. This makes Clear Data useful for capturing a fresh set of data from another application or selectively generating a fresh column of random numbers.

1.

Click the column or columns that you want to clear.

2.

From the Data menu, select Clear Data.

Note: If a recalculated formula produces the same data as before, it may appear that the Clear Data command has failed.