▶ | 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.