In this lesson, you will learn how to rearrange your worksheet by adding and deleting cells, rows, and columns.
Sometimes, you will need to insert information into a worksheet, right in the middle of existing data. With the Insert command, you can insert one or more cells, or entire rows or columns.
Panic Button: Shifting Cells Inserting cells in the middle of existing data will cause those other cells to shift down a row or over a column. If you added formulas to your worksheet that rely on the contents of the shifting cells, this could throw off the calculations (see Lessons 13 and 14). Your formulas are affected when you insert a cell or group of cells. However, formulas adjust automatically when you insert entire rows or entire columns.
To insert a single cell or a group of cells:
Figure 12.1
The Insert dialog box.
Timesaver Tip: Drag Insert A quick way to insert cells is to hold down the Shift key while dragging the fill handle (the little box in the lower right corner of the selected cell(s)). Drag the fill handle up, down, left, or right to set the position of the new cells.
In Lesson 11, you learned how to clear the contents and formatting of selected cells. This merely removed what was inside the cells. If you want to remove the cells completely, perform the following steps:
Figure 12.2
The Delete dialog box asks where you want surrounding cells shifted.
Inserting entire rows and columns in your worksheet is similar to inserting a cell(s). Here's what you do:
Timesaver Tip: Shortcut Insert To quickly insert rows or columns, select one or more rows or columns, and then right-click on one of them. Choose Insert from the shortcut menu.
Figure 12.3
Inserting a row in a worksheet.
Deleting rows and columns is similar to deleting cells. When you delete a row, the rows below the deleted row move up to fill the space. When you delete a column, the columns to the right shift left. To delete a row or column:
Figure 12.4
Deleting a row in a worksheet.
In this lesson, you learned how to insert and delete cells, rows, and columns. In
the next lesson, you will learn how to use formulas.
© Copyright, Macmillan Computer Publishing. All rights reserved.