Insert More Than One Row in Excel

  1. To select the selected cell’s entire row, press Shift + Spacebar
    To select more rows, press Shift, and the Up arrow or Down arrow.
    To insert the selected number of rows, press Ctrl + + (plus sign)
  2. Name Range: Input rows range -> Enter -> Ctrl++(plus sign)