Dr. GwenNURSING · EDUCATION · SCHOLARSHIP

EXCEL · DATA SKILLS

Insert and delete rows

Browse Excel lessons
  1. Excel for basic data analysis
  2. Cells and ranges
  3. Columns and readable headings
  4. Enter and edit cells
  5. Share files and embed objects
  6. Fill a series
  7. Save a practice copy
  8. Prepare data for analysis
  9. Dates and number formats
  10. Variables and score definitions
  11. Enter and check practice data
  12. Insert and delete rows
  13. AutoSum and totals
  14. Copy formulas with relative references
  15. Calculate the mean
  16. Calculate standard deviation
  17. Excel references and next steps

Keep the sample layout intact for the remaining lessons. Practice inserting and deleting rows in a separate copy.

  1. Select a row number and right-click.
  2. Choose Insert to add a row above it, or Delete to remove the row.
  3. Use Undo to return to the original layout.

Pressing Delete on selected cells clears contents; it does not remove the worksheet row. Inserting or deleting rows can move the summary cells, so check formula ranges afterward. To sort a real dataset, select the complete data table so each case stays together.

Reference: Microsoft Support. Menu names may vary by platform and update.

← Previous lesson · Next lesson →