Inserting, Deleting, and Hiding Columns and Rows

Merging cells hints at some other important ways in which you can modify the structure of the worksheet itself, in addition to the data that the worksheet contains. There may be times when you need to insert or delete a row or column in the worksheet. Say you've constructed a list of employees along with identifying column headings, as in Figure 5–40.

Figure 5–40. The headings for an employee directory. Note the columns have been autofit.

It then occurs to you that you've inadvertently omitted a Salary field, which you want sandwiched between Telephone Number and Dept. You'll need to insert a column.

Inserting a Column or Row

As usual, there are several ways in which to do this. Here's one: