- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Inserting and Deleting Rows
You can insert extra rows into a worksheet to make more room for additional data or formulas. Adding more rows, which gives the appearance of adding space between rows, can also make the worksheet easier to read. Alternatively, you can delete rows from a worksheet to close up some empty space or remove unwanted information.
)
Right-click on the row number of the existing row where you want to insert a new row.
Click the Insert option. Excel automatically adds a new row.
To delete a row, right-click on the row number of the existing row that you want deleted.
Click the Delete option. Excel automatically removes the specified row.
Tip: Hide Rows instead of Delete Rows
If there is a chance you will need the rows you are deleting, another alternative is to leave them intact—only hidden. Hide them by selecting your rows, right-clicking, and then selecting the Hide option. This way, the rows will not be visible, but you can always get them back by unhiding them.