MS-Excel

Adding a Row or a Column

Sometimes, you may forget to insert one or more columns and/or rows in a table. However, you do not have to start over because Excel has a function that allows you to insert rows and/or columns.

In our example, we will add a row after the row containing the word "Hammer". When you add a row, all rows will automatically move down one row. For example, if you insert a row after the word "Hammer" (third row), you must insert a new row at the fourth row. The fourth row, and everything in it, will become the fifth row, and so on.

Move your pointer to where the word "Table" appears and click the right mouse button. The following menu will be displayed:

wpe58.gif (2947 bytes)
(Figure 2.10)

Select the Insert option to insert a row or a column. The following menu will then be displayed:

wpe59.gif (1827 bytes)
(Figure 2.11)

This menu offers four choices, described:

Table2.1

wpe5E.gif (7439 bytes)

Choose the Entire Row option to insert a row. You should see a blank line in the fourth row, as shown in the following figure:

wpe61.gif (4243 bytes)
(Figure 2.12)

Add the word "Axe" in cell A4.

If you prefer to use the Excel menu rather than the mouse to insert a row, you can choose the Insert menu, then Row.

Back to Index