Jiangws's Blog

Insert More Than One Row in Excel

Written by

jiangws

in

  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)
https://www.wallstreetmojo.com/insert-multiple-rows-in-excel/

More posts