Office 2008 for Macintosh: The Missing Manual

Insert Menu

If you want to insert something into your Excel documents, then this menu is your best friend. If not, there’s no need to go to its parties.

Cells

Inserts a number of blank cells equivalent to the number you’ve first selected, and opens the Insert window, which lets you set how those cells are placed.

Rows

Inserts a number of blank rows equivalent to the number you’ve first selected, moving the selected rows down. If you have only one cell selected, Excel inserts only one row.

Columns

Inserts a number of blank columns equivalent to the number you’ve first selected, moving the selected columns to the right. If you only have one cell selected, Excel inserts only one column.

Chart

Opens the Charts Gallery, which walks you through the creation of a chart, and then it inserts your newly minted chart either into the currently active worksheet or into a whole new sheet reserved for the chart alone.

List

Opens the List Wizard, which walks you through the creation of one of Excel’s fancy list objects (see Excel, the List Maker).

Sheet

Lets you choose from its submenu a Blank Sheet, a Chart Sheet, or a List Sheet to insert into your current workbook. Choose Other to pick a worksheet from the Project Gallery or from some other folder.

Page Break

Inserts a page break above the currently selected cell. If the cell is adjacent to a manually placed page break, this command changes to Remove Page Break, which (as you might guess) removes the break.

Function

Opens the Formula Builder, from which you ...