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 can select one of Excel’s functions to insert into the currently active cell.

Name

The Name menu has four submenu choices that let you deal with names in Excel worksheets. Names are plain-English ways of referring to a cell or selection of cells (see Named ranges).

  • Define. Opens the Define Name window, where you can add or delete names for a cell or group of cells.

  • Paste. Opens the Paste Name window, which you can use to paste a named group of cells into a formula. You can also paste a list of your defined names, including the cells to which those names refer.

  • Create. Opens the Create Names window, which lets you create names based on labels in selected cells.

  • Apply. Opens the Apply Names window, where you can choose a name range to replace a cell range inside a formula. That cell range has to match an existing named cell ranges; otherwise, the function doesn’t work.

Comment

Inserts a comment attached to the selected cell or cells.

Picture

The Insert → Picture submenu lets you grab images from one of six sources. You can read about them in detail in Chapter 20, but here’s a summary:

  • Clip Artopens the Clip Gallery and lets you select a bit of Office clip art to insert.

  • From File brings up the “Choose a Picture” dialog box, which lets you find and insert your own picture files.

  • Shapeopens the Object Palette; you can start drawing in your worksheet using the AutoShapes tools.

  • Organization Chart opens Microsoft Organization Chart, which lets you create and insert your own flow charts into the currently active Excel worksheet.

  • WordArt. Opens the WordArt Gallery, where you can create text art for insertion into the currently active sheet.

Text Box

Lets you draw a text box onto your spreadsheet.

Movie

Brings up the Insert Movie dialog box, where you can select a QuickTime, AVI, or MPEG movie to insert into the currently active sheet.

Object

Opens the Insert Object window, where you can select one of the following Office object types for insertion: an Equation object, a Microsoft Graph Chart object, Microsoft Organization Chart object, or a Word Document object.

Hyperlink

Opens the Insert Hyperlink window, where you can insert a new hyperlink to a Web page, a document, or an email address. If there’s already a link in the selected cell, this command opens the link for editing. Keyboard shortcut: ⌘-K.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.140.188.244