Microsoft Office Tutorials and References
In Depth Information
Deleting rows and columns
To insert a new column or columns, use either of these methods:
Select an entire column by clicking its column letter in the worksheet border,
also known as the column header. (Ctrl+click to select multiple adjacent columns.)
Right-click and choose Insert from the shortcut menu.
Move the cell pointer to the column that you want to insert, and then choose
Home Cells Insert Insert Sheet Columns. If you select multiple cells in
the row, Excel inserts additional columns that correspond to the number of cells
selected in the row.
You can also insert cells, rather than just rows or columns. Select the range into which you
want to add new cells and then choose Home
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. Notice that this
dialog box also enables you to insert entire rows or columns.
Cells
Insert
FIGURE 14.11
You can insert partial rows or columns by using the Insert dialog box.
Deleting rows and columns
You may also want to delete rows or columns in a worksheet. For example, your sheet
may contain old data that is no longer needed, or you may want to remove empty rows or
columns.
14
To delete a row or rows, use either of these methods:
Select an entire row or multiple rows by clicking or Ctrl+clicking the row
numbers in the worksheet border (row header). Right-click and choose Delete
from the shortcut menu.
Move the cell pointer to the row that you want to delete, and then choose
Home
Delete Sheet Rows. If you select multiple cells in the column, Excel
deletes all rows in the selection.
Cells
Deleting columns works in a similar way. If you discover that you accidentally deleted a row
or column, select Undo from the Quick Access Toolbar (or press Ctrl+Z) to undo the action.
Search JabSto ::




Custom Search