1. In the Excel worksheet, highlight the specific number of rows or columns to insert.
  2. Right-click and select Insert.
OR
  1. In the Excel worksheet, highlight the specific number of rows or columns to insert.
  2. Select Insert, Rows or Columns from the menu bar.