Although the number of rows and columns in a worksheet is fixed, you can still insert and delete rows and columns if you need to make room for additional information. These operations don’t change the number of rows or columns. Rather, inserting a new row moves down the other rows to accommodate the new row.

The last row is simply removed from the worksheet if it’s empty. Inserting a new column shifts the columns to the right, and the last column is removed if it’s empty.

To insert a new row or rows, you can use any of these techniques:

• Select an entire row or multiple rows by clicking the row numbers in the worksheet border. Rightclick and choose Insert from the shortcut menu.
• Move the cell pointer to the row that you want to insert and then choose Home?Cells?Insert? Insert Sheet Rows. If you select multiple cells in the column, Excel inserts additional rows that correspond to the number of cells selected in the column and moves the rows below the insertion down.

The procedures for inserting a new column or columns is similar, but you choose Home?Cells?Insert? Insert Sheet Columns.

You also can insert cells, rather than just rows or columns. Select the range into which you want to add new cells and then choose Home?Cells?Insert?Insert Cells (or right-click the selection and choose Insert).

To insert cells, the existing cells must be shifted to the right or shifted down. Therefore, Excel displays the Insert dialog box shown in Figure 14-11 so that you can specify the direction in which you want to shift the cells.

FIGURE 14-11
You can insert partial rows or columns by using the Insert dialog box.

• Apple's New iPhone 4 - Summarized [/caption] The Apple iPhone 4 is everything that a new piece of technology should be: It's innovative, attractive, and ahead...
• HQRP 100 Watt Solar Panel 100W Power 12V Monocrystalline 12 Volt PV Module DC Battery Charger RV Marine Yacht Boat Car + HQRP Mousepad HQRP™ Solar Panels plus HQRP™ Mousepad;Rated Power: 50W; Maximum Power Voltage: 17.6V; Open Circuit Voltage: 21.6V;Maximum Power Current: 2.85A; Short...
• Choosing the Ideal Fishing Boat In this article we are going to take a look at different fishing boats in order to determine which will...
• Scarf using eyelash yarn in combo Another combination that is nice is most any yarn carried with an eyelash yarn. Choose any two yarns that you...
• Target Retirement Funds Portfolio Composition And Expenses: Vanguard vs Fidelity vs T Rowe Price This is the first post in a series comparing and contrasting target retirement funds from three competing companies: Vanguard, Fidelity,...