O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Insert Menu

The Insert menu gives you one-stop shopping for adding a variety of items to your worksheet, including new rows and columns, charts, functions, comments, and hyperlinks.

Cells

Use this command to insert a new cell in your worksheet. Insert Cells opens the Insert dialog box, where you can choose how to move existing data out of the way (either by pushing it down the spreadsheet or to the right). You can also use this command to insert multiple cells at once: just select the area where you want to insert new cells before you select Insert Cell.

Rows

Insert Rows places a new row in your worksheet and shifts the rest of the worksheet data down to make space.

Columns

Insert Columns places a new column in your worksheet and shifts the rest of the worksheet data to the right to make space.

Worksheet

This command inserts a new, blank worksheet into your workbook. To learn more about managing workbooks with multiple worksheets, see Chapter 5.

Chart

The Chart Wizard (Insert Chart) lets you configure and generate a new chart. To make your life easy, select the data you want to place in the chart before selecting Insert Chart. For a step-by-step overview of the Chart Wizard, see Section 16.1.2 (Chapter 16).

Symbol

The Symbol dialog box (Insert Symbol) lets you pick from, and enter into your worksheet, special characters (like a smiley face

image with no caption

or the copyright symbol ©). Just ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required