|▶||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 Minimize Column Width.|
|-||For a row, you can choose Resize Row Height.|
The tools that minimize and maximize 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.