Marrathon.com - Dave Marra's Web Site!

Marrathon.com - Dave Marra's Web Site!

Marrathon.com - Dave Marra's Web Site!

Marrathon.com - Dave Marra's Web Site!

Increase or decrease size of all text in a table in Numbers

In Numbers, to increase or decrease size of all text proportionally in a selected table, use the Table Font Size section of the Table format sidebar.

Unlock a locked table or chart in Numbers

In Numbers, to unlock a locked table or chart, select it, then click Unlock in the Arrange pane of the Format inspector.

Add a star rating to a cell in Numbers

In Numbers, to add a star rating to a selected cell, click Cell in the Format sidebar, then choose Star Rating from the Data Format pop-up menu.

Select additional rows below the selected row in Numbers

In Numbers, after selecting a row in a table, press Shift–Down Arrow to quickly select additional rows below the selected row.

Copy a chart in a sheet to PDF format in Numbers

In Numbers, to copy a chart in a sheet to PDF format, Control-click the chart, then choose “Copy as PDF” from the pop-up menu.

Add a new sheet to a spreadsheet in Numbers

In Numbers, to add a new sheet to a spreadsheet, choose Insert> New Sheet, or press Shift-Command-N.

Turn off alternating table row colors in Numbers

In Numbers, to turn off alternating row colors for a selected table if they are enabled, click the Table button in the Format inspector, then deselect Alternating Row Color.

Wrap text in numbers

In Numbers, to wrap text so it appears on multiple lines in a cell, select the cell, then choose Table>Wrap Text.

Select the next object on a sheet in Numbers

In Numbers, press Tab to select the next object on a sheet.

Filter by a specific cell’s value in Numbers

In Numbers, to filter by a specific cell’s value, Control-click the cell, then choose Filter Table by "[cell value]".

Constrain the movement of a table in Numbers

When moving a table in Numbers, hold the Shift key while dragging to constrain the movement of the table and snap to guides.

Set a default text box for a spreadsheet in Numbers

In Numbers, to create your own default text box style for a spreadsheet, change a text box however you want, then select the text box and choose Format> Advanced> Set as Default Text Box Appearance.

Make text superscript in Numbers

In Numbers, press Control-Shift-Command-Plus (+) to make selected text superscript.

Zoom into a selected area of a spreadsheet in Numbers

In Numbers, to zoom into a selected area of a spreadsheet, choose View> Zoom> Zoom to Selection, or press Shift-Command-0.

Select all cell content in a table in Numbers

In Numbers, to select all cell content in a table, select any cell, then press Command-A.

Rename a sheet in Numbers

In Numbers, to rename a sheet, double-click its name in its tab, then type a new name.

Quickly move down a page in a spreadsheet in Numbers

In Numbers, to quickly move down a page in a spreadsheet, press Control-V.

Resize a column to fit its contents in Numbers

In Numbers, to resize a column to fit its contents, Control-click the column letter, then choose Fit Width to Content from the pop-up menu.

Transpose rows and columns in a table in Numbers

In Numbers, to transpose the rows and columns in a table to switch them, select the table, then choose Table> Transpose Rows and Columns.

Select additional rows above the selected row in Numbers

In Numbers, after selecting a row in a table, press Shift–Up Arrow to quickly select additional rows above the selected row.

Select the previous object on a sheet in Numbers

In Numbers, press Shift-Tab to select the previous object on a sheet.

Make text subscript in Numbers

In Numbers, press Control-Command-Minus (-) to make selected text subscript.

Set a specific size for a chart in Numbers

In Numbers, to set a specific size for a selected chart, click the Arrange tab at the top of the sidebar, then in the Size section, type values for Width and Height.

Rename a custom template in Numbers

In Numbers, to rename a custom template, Control-click the template name in the My Templates section of the template chooser, then choose Rename from the pop-up menu.

Quickly select an entire row or column in Numbers

In Numbers, to quickly select an entire row or column in a selected table, click the lettered bar for the column or the numbered bar for the row.

Edit chart data in Numbers

In Numbers, to edit a chart's data references, select the chart, then choose Format> Chart> Edit Chart Data, or press Shift-Command-D.

Connect two objects with a line in Numbers

In Numbers, to connect two objects with a line, select the objects, then Control-click them and choose "Add Connection Line" from the pop-up menu.

Extend cell selection by one cell in Numbers

In Numbers, after selecting a cell in a table, press Shift and an arrow key to extend the cell selection by one cell.

Show a chart's title in Numbers

In Numbers, to show a chart's title, Control-click the chart, then select "Show Title" from the pop-up menu.

Quickly move to the end of the current text area in Numbers

In Numbers, press Command–Down Arrow to quickly move to the end of the current text area.

Unhide all rows or columns in Numbers

In Numbers, to show all hidden rows or hidden columns in a selected table, choose Table> Unhide All Rows or Unhide All Columns.

Select additional columns in Numbers

In Numbers, after selecting a column in a table, press Shift–Right Arrow or Shift–Left Arrow to quickly select additional columns.

Move the Formula Editor in Numbers

In Numbers, when inserting a formula into a cell using the Formula Editor, to move the Formula Editor, drag its left side.

Wrap text in table cells in Numbers

In Numbers, to wrap text in table cells, select the cell, then click the Text tab in the Format inspector sidebar and select "Wrap text in cell".

Zoom in Numbers

In Numbers, press Shift-Command-Period (.) to zoom in.

Delete a sheet in Numbers

In Numbers, to delete a sheet, move the pointer over the right side of the sheet's tab, then click the arrow that appears, then choose Delete.

Resize a table proportionally in Numbers

In Numbers, when resizing a selected table, to resize it proportionally, Shift-drag the white square in the bottom-right corner.

Add a checkbox to cells in Numbers

In Numbers, to add a checkbox to selected cells, click the Cell tab in the Format sidebar, then choose "Checkbox" from the Data Format pop-up menu.

Add a link to selected text in Numbers

In Numbers, to add a link to selected text, Control-click the text, then choose "Add Link", then select an option from the "Link to" pop-up menu.

Save a spreadsheet as a custom template in Numbers

In Numbers, to save a spreadsheet as a custom template to use again as a model for other spreadsheets, choose File> Save as Template.

Set the default zoom level in Numbers

In Numbers, to set the default zoom level to use when opening spreadsheets, choose Numbers> Preferences> General, then choose an option from the Default Zoom pop-up menu.

Move a table in Numbers

In Numbers, to move a table, click anywhere in the table to select it, then drag the round table handle in the top-left corner to move it.

Quickly move to the beginning of the current text area in Numbers

In Numbers, press Command–Up Arrow to quickly move to the beginning of the current text area.

Add a border around a chart in Numbers

In Numbers, to add a border around a chart, select the chart, then click Format> Chart and select the Border checkbox in the Chart Options section.

Insert a new column on the right edge of a table in Numbers

In Numbers, to insert a new column on the right edge of a table, select a cell in the right-most column, then press Tab.

Return to actual size in Numbers

In Numbers, when zoomed in or out, press Command-0 to return to actual size.

Jump to the last sheet in Numbers

In Numbers, press Option-Command-Shift-Right Bracket (}) to jump to the last sheet.

Print every sheet in a spreadsheet in Numbers

When printing in Numbers, select the "All Sheets" option in the Print Setup window to print every sheet in your spreadsheet, instead of only the current one.

Send a copy of a spreadsheet via Messages in Pages

In Numbers, to send a copy of a spreadsheet via Messages, click the Share button in the toolbar, then choose Send a Copy> Messages.

Show the rulers in Numbers

In Numbers, to show the rulers, choose View> Show Rulers, or press Command-R.

Reduce the file size of a spreadsheet in Numbers

In Numbers, to reduce the file size of a spreadsheet by compressing any images contained in it, choose File> Reduce File Size.

Filter data in Numbers

In Numbers, to filter data, click the down arrow at the top of a column, then choose "Filter Data" and choose the value to filter by.

Hide the rulers in Numbers

In Numbers, to hide the rulers if they are showing, choose View> Hide Rulers, or press Command-R.

Go to the next sheet in Numbers

In Numbers, press Fn-Command-Down Arrow to go to the next sheet.

Zoom out in Numbers

In Numbers, press Shift-Command-Comma (,) to zoom out.

Find selected text in Numbers

When the Find window is open in Numbers, to find selected text in the spreadsheet, select the text, then press Command-E.

Jump to the first sheet in Numbers

In Numbers, press Option-Command-Shift-Left Bracket ({) to jump to the first sheet.

Resize a chart in Numbers

In Numbers, to resize a chart, select the chart, then drag any of the selection handles (white squares) on the chart’s border to make it larger or smaller.

Change a chart’s type in Numbers

In Numbers, to change a chart’s type, select it, then in the Chart pane of the Format inspector, choose an option from the Chart Type pop-up menu.

Enlarge a sheet in Numbers

In Numbers on a Mac with a Multi-Touch trackpad, pinch open to enlarge the selected sheet.

Insert a row at the bottom of a table in Numbers

In Numbers, to insert a row at the bottom of a table, select a cell in the bottom row, then press Return.

Lock a table in Numbers

In Numbers, to lock a table so it can’t be edited, moved, or deleted, select the table, then click Lock in the Arrange pane of the Format inspector.

Select the next cell in Numbers

In Numbers, press Tab to select the next cell.

Change the position of a wedge in a pie chart in Numbers

In Numbers, to change the position of a wedge in a pie chart, select the chart, then select the wedge and drag it.

Password-protect a spreadsheet in Numbers

In Numbers, to assign a password to a spreadsheet so that only those who know the password can open it, choose File> Set Password.

Print without a preview in Numbers

In Numbers, to print without a preview, hold Option and choose File> Print Without Preview, or press Option-Command-P.

Use a default template in Numbers

In Numbers, to use a default template, choose Numbers> Preferences> General, then select "Use template", then click "Change Template" and select a default template.

Highlight text within a text box in Numbers

In Numbers, to highlight text within a text box, select the text, then choose Insert> Highlight.

Reorganize sheets in Numbers

In Numbers, when working in a spreadsheet containing multiple sheets, drag a sheet's tab left or right to reorganize them.

Hide a row in Numbers

In Numbers, to hide a row, click the row's reference tab, then choose "Hide Row" from the pop-up menu.

Resize rows to fit content in Numbers

In Numbers, to resize selected rows so that the row height matches the cell with the tallest content, choose Table> Resize Rows to Fit Content.

Select the previous cell in Numbers

In Numbers, press Shift-Tab to select the previous cell.

Change the default table style in Numbers

In Numbers, to change the default table style, click the arrow to the right of the style and choose "Set as Default Style for New Tables".

Delete a single column in Numbers

In Numbers, to delete a single column, hold the pointer over the column reference tab, then choose Delete Column from the pop-up menu.

Select nonadjacent cells in a table in Numbers

In Numbers, to select nonadjacent cells in a table, hold down the Command key while selecting each cell.

Scroll to the end of a sheet in Numbers

In Numbers, press Fn-Right Arrow to quickly scroll to the end of the selected sheet.

Shrink a sheet in Numbers

In Numbers on a Mac with a Multi-Touch trackpad, pinch closed to shrink the selected sheet.

Add page numbers to a spreadsheet in Numbers

In Numbers, to add page numbers to a spreadsheet, place the insertion point where you want the page number to appear, then choose Insert> Page Number.

Go to the previous sheet in Numbers

In Numbers, press Fn-Command-Up Arrow to go the previous sheet.

Change a sheet's name in Numbers

In Numbers, to change a sheet's name, double-click its name in the Sheets pane located along the left edge of the window, then type a new name and press Return.

Hide a column in Numbers

In Numbers, to hide a column, click the column's reference tab, then choose "Hide Column" from the pop-up menu.

Toggle on or off font previews in Numbers

In Numbers, to toggle on or off font previews in the Format Bar font menu, hold the Option key, then click the menu.

Password-protect a spreadsheet in Numbers

In Numbers, to add a password to a spreadsheet, show the Inspector, click the Document inspector, then select "Require password to open”.

Open multiple Inspector windows in Numbers

In Numbers, Option-click any button on the top of the Inspector to open a new Inspector window for that button.

Add color to a cell, row, or column in Numbers

In Numbers, to add color to a selected cell, row, or column, click the Fill well in the format bar then choose a color.

Make all rows in a table the same size in Numbers

In Numbers, to make all rows in a table the same size, select any column in the table, then choose Table> Distribute Rows Evenly.

Scroll to the beginning of a sheet in Numbers

In Numbers, press Fn-Left Arrow to quickly scroll to the beginning of the selected sheet.

Duplicate a sheet in Numbers

In Numbers, to duplicate a sheet, Control-click the sheet in the sidebar and choose Duplicate from the pop-up menu.

Use border selection mode in Numbers

In Numbers, to use border selection mode, to allow the selection of border segments in a table, choose Table> Allow Border Selection.

Copy a column in Numbers

In Numbers, to copy a column elsewhere in a table, click its reference tab to select it, then hold Option and drag the column to the desired location.

Insert a column after a cell in Numbers

In Numbers, press Option-Right Arrow to insert a new column after a selected cell.

Add a comment to a cell in Numbers

In Numbers, to add a comment to a cell, select the cell, then click the Comment button in the toolbar, or choose Insert> Comment.

Use alternating table row colors in Numbers

In Numbers, to use alternating row colors for a selected table, choose View> Show Inspector, then click the Table inspector button and select Alternating Row Color.

Select a table in Numbers

In Numbers, when editing a cell in a table, press Command-Return twice to select the table.

Split a table cell or cells into two equal colums in Numbers

In Numbers, to split a selected table cell or cells into two equal columns, choose Table> Split into Columns.

Merge table cells in Numbers

In Numbers, to merge table cells by combining adjacent cells into one, select a group of two or more adjacent cells, then choose Table> Merge Cells.

Add a new row above a cell in Numbers

In Numbers, press Option-Up Arrow to add a new row above a selected cell.

Keep header rows visible in Numbers

In a Numbers spreadsheet, to keep header rows visible when scrolling, choose Table> Freeze Header Rows.

Resize columns to fit content in Numbers

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

In Numbers, to hide a chart's title, Control-click the chart and select "Hide Title" from the pop-up menu.

Duplicate a table in Numbers

In Numbers, to duplicate a table, Control-click the table in the sidebar and choose Duplicate from the pop-up menu.

Preview a Numbers template before opening it

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 rows in Numbers

In Numbers, to split a selected table cell or cells into two equal rows, choose Table> Split into Rows.

Copy a row in Numbers

In Numbers, to copy a row elsewhere in a table, click its reference tab to select it, then hold Option and drag the row to the desired location.

Select an object after editing text within it in Numbers

In Numbers, after typing text within an object, press Command-Return to exit text edit mode and select the object.

Maximize the number of currency symbols available in Numbers

In Numbers, to maximize the number of currency symbols available, choose Numbers> Preferences> General and choose "Show complete list of currencies in Cells inspector".

Make all columns in a table the same size in Numbers

In Numbers, to make all columns in a table the same size, select any row in the table, and then choose Table> Distribute Columns Evenly.

Insert a paragraph break in a cell in Numbers

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

In Numbers, press Option-Down Arrow to add a new row below a selected cell.

Select a cell in Numbers

In Numbers, when editing a cell in a table, press Command-Return to select the cell.

Copy the contents of one cell into another cell in Numbers

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

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

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

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

In a Numbers spreadsheet, to keep header columns visible when scrolling, choose Table> Freeze Header Columns.

Insert a column before a cell in Numbers

In Numbers, press Option-Left Arrow to insert a new column before a selected cell.

Adjust print size of Numbers spreadsheets

To print large spreadsheets from Numbers '09 onto a single page, choose View> Show Print View then slide the Content Scale, at the bottom, to adjust print size.