Add a new row above a cell in Numbers
02/05/2012
In Numbers, to add a new row above a selected cell, press Option-Up Arrow.
Keep header rows visible in Numbers
01/08/2012
In a Numbers spreadsheet, to keep header rows visible when scrolling, choose Table> Freeze Header Rows.
Resize columns to fit content in Numbers
12/15/2011
In Numbers, to adjust the width of selected columns to accommodate their largest content, choose Table> Resize Columns to Fit Content.
Hide a chart's title in Numbers
12/03/2011
In Numbers, to hide a chart's title, Control-click the chart and select "Hide Title" from the pop-up menu.
Duplicate a sheet or table in Numbers
11/03/2011
In Numbers, to duplicate a sheet or table, Control-click it in the sidebar and choose Duplicate from the pop-up menu.
Preview a Numbers template before opening it
09/25/2011
In the Template Chooser in Numbers, move your pointer over the thumbnail of a multi-page template to preview all of the pages contained within it.
Split a table cell or cells into two equal parts in Numbers
09/14/2011
In Numbers, to split a selected table cell or cells into two equal parts, choose Table> Split into Rows, or Table> Split into Columns.
Copy a row or column in Numbers
08/24/2011
In Numbers, to copy a row or column elsewhere in a table, click its reference tab to select it, then hold Option and drag the row or column to the desired location.
Maximize the number of currency symbols available in Numbers
06/27/2011
In Numbers, to maximize the number of currency symbols available, do Numbers> Preferences> General and choose "Show complete list of currencies in Cells inspector".
Make all columns in a table the same size in Numbers
05/29/2011
In Numbers, to make all columns in a table the same size, select the table or one or more rows, and then choose Table> Distribute Columns Evenly.
Insert a paragraph break in a cell in Numbers
04/27/2011
In Numbers, when editing text or formulas in a cell, press Option-Return to insert a paragraph break (hard return) in the text.
Add a new row below a cell in Numbers
04/13/2011
In Numbers, to add a new row below a selected cell, press Option-Down Arrow.
Quickly select a cell or table in Numbers
04/02/2011
In Numbers, when editing a cell in a table, hit Command-Return to select the cell or Command-Return twice to select the table.
Copy the contents of one cell into another cell in Numbers
03/21/2011
In Numbers, to copy the contents of a selected cell into another cell, press Option while dragging the selected cell's contents to the other cell.
Hide a chart's legend in Numbers
01/04/2011
In Numbers, to hide a chart's legend, Control-click the chart and select "Hide Legend" from the pop-up menu.
Select a table in a Numbers spreadsheet
11/27/2010
To select a table in a Numbers spreadsheet, click any cell in the table to select it, then Command-click the selected cell to select the entire table.
Move contents between cells in a Numbers spreadsheet
10/28/2010
To move contents of a selected cell in a Numbers spreadsheet into another cell, drag the cell by its border into the destination cell, then release.
Keep header columns visible in Numbers
09/18/2010
In a Numbers spreadsheet, to keep header columns visible when scrolling, choose Table> Freeze Header Columns.
Insert a column before or after a cell in Numbers
08/13/2010
In Numbers, to insert a new column after a selected cell, press Option-Right Arrow. To insert it before a selected cell, press Option-Left Arrow.
Adjust print size of Numbers spreadsheets
02/28/2010
To print large spreadsheets from Numbers '09 onto a single page, do View>Show Print View then slide the Content Scale, at the bottom, to adjust print size.
