Inserting and Deleting Rows and Columns

Sometimes you need to go back to an existing spreadsheet and insert some new information.

Insert a Row or Column

To insert a new row or column in the middle of your spreadsheet, follow these steps:

1.	Click the row or column header after where you want to make the insertion.
2.	Pull down the Insert menu and select either Insert Row or Insert Column.

Excel now inserts a new row or column either above or to the left of the row or column you selected.

Delete a Row or Column

To delete an existing row or column, follow these steps:

1.	Click the header for the row or column you want to delete.
2.	Pull down the Edit menu and select Delete.

The row or column you selected is deleted, and all other rows or columns move up or over to fill the space.

Adjusting Column Width

If the data you enter into a cell is too long, you'll only see the first part of that datathere'll be a bit to the right that looks cut off. It's not cut off, of course; it just can't be seen, because it's longer than the current column is wide.

You can fix this problem by adjusting the column width. Wider columns allow more data to be shown; narrow columns let you display more columns per page.

To change the column width, move your cursor to the column header, and position it on the dividing line on the right side of the column you want to adjust. When the cursor changes shape, click the left button on your mouse and drag the column divider to the right (to make a wider column) or to the left (to make a smaller column). Release the mouse button when the column is the desired width.

tip

To make a column the exact width for the longest amount of data entered, position your cursor over the dividing line to the right of the column header and double-click your mouse. This makes the column width automatically "fit" your current data.