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.

• Use Correlation Test of MS Excel Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient...
• Green Home Makeovers that are Easy and Affordable Are you looking to save the environment, but you cannot afford costly options like solar panels? Are you looking for...
• 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,...
• 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...
• 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...