Often you want to insert or delete rows or columns. Note that deleting a row or column is not the same as clearing the contents of a row or column—making all of its cells blank. Deleting a row or column means wiping it out completely.
To insert one or more blank rows:
Click on a row number and drag down as many rows as you want to insert. Then click on the Insert dropdown and select Insert Sheet Rows. (Interestingly, the Insert dropdown is in the Cells group of the Home ribbon, not on the Insert ribbon.)
The rows you insert are inserted above the first row you selected. For example, if you select rows 8 through 11 and then insert, four blank rows will be inserted between the old rows 7 and 8.
Try it! Insert blank rows for the data for Feb, Apr, and May.
Columns are inserted in the same way.
Try it! Insert blank columns for sales reps Baker, Miller, and Smith (so that the sales reps are in alphabetical order from left to right).
To delete one or more rows:
Click on a row number and drag down as many rows as you want to delete. Then select the Delete dropdown and select Delete Sheet Rows. Columns are deleted in exactly the same way.
Try it! The company no longer carries products K322 and R543, so get rid of their rows.
Dostları ilə paylaş: |
