Insert multiple rows and columns quickly in Excel

If you’ve done a lot of work in Excel, you know that you can select multiple rows or columns, use the Copy command, and then right click and select Insert Copied Cells. But you can only do this once per copy, and there’s a faster way.

Select however many rows (or columns) that you want to insert – it doesn’t matter if they’re empty, but they must include the location where you want to perform the insert. Now click anywhere within this range of selected cells, right click and select Insert. That’s it. Any existing content will be moved down (or right) to make room for the number of rows (or columns) you had selected.

Right click to Insert in Excel

You can repeat this as many times as you need as long as your rows (or columns) remain selected.


Comments (23)

  1. stan says:

    is there some way to just say "insert 77 rows" instead of painstakingly selecting precisely 77 rows first?

  2. Trying to Save Time says:

    Negative….I tried this in numerous forms and fashions and no matter what the data that is in place is overwritten, not moved down, as desired.

  3. sam says:

    Thanks for useful information. Keep up the good work!

  4. Ricky says:

    Here is a short video that explains how to quickly insert multiple rows, I believe columns should follow the same steps respectively

  5. Brent says:

    You indicate that the selected rows "must include the location".  How do they include the location?

  6. GUS says:

    to insert 77 rows, just select 11 rows and paste 7 times. I don't know of a simpler solution, but it's a start.

  7. Reynold says:

    Just wanted to share another easier way to this.

    First insert a single row manually (by right click menu) and after that repeatedly press the 'F4' key and "puff" multiple rows added!

    I read this at:…/insert-multiple-rows-in-excel

  8. Siddhu says:

    Select multiple rows and press Ctrl +, this keyboard shortcut is a bit handy.

  9. rahul says:

    Thanks Siddhu..its working great!!!!

  10. Ingrid says:

    What is the mac equivalent for the f4 key?

  11. Waterworld says:

    This note is for Reynold Feb 2013 – you are my new BEF or Best Excel Friend.  I love this shortcut!!!!!!!!!!!!!!!!!!!!!!!!

  12. Nicole says:

    Amen to that Waterworld!  REYNOLD is AWESOME!  That was great!  so sick of "Insert… Entire row… " blah blah.  YAY!  I'm free!!!!!!!!!!

  13. LaliSmile says:

    Raynold you saved my life jajaja…thanks for the info… worked perfectly!!!!

  14. Sanddie says:

    i agree with Waterworld! Reynold- that is an amazing tip!

  15. gotorg says:

    To insert multiple rows, select the rows above which you want to insert rows. Select the same number of rows as you want to insert. For example, to insert three new rows, you need to select three rows.…/insert-rows-columns-or-cells-HP005200926.aspx

  16. Sammy says:

    helped out heaps thank u soooooooooooo much

  17. Peter Fane says:

    In Mac office and versions of Windows office earlier than 2010, you could select the 77 rows once and then select a row where you wanted the top row to be inserted and then select "insert copied cells" as  many times as you liked.  It is Excel 2010 that is the problem and Microsoft should fix the damned thing!!

  18. Peter Fane says:

    Switch to the Mac version. You can insert copied rows etc as many times as you like without having to recopy each time.

  19. jeremy says:

    Works except the part about, "You can repeat this as many times as you need as long as your rows (or columns) remain selected." In practice- it will only work 1 time. Each additional time, your selection has to be re-copied to the clipboard before it can be inserted. – Baby steps, someday you will get there MS.

  20. joyce says:

    Reynold, You are awesome! Thank you for the tip!!!

  21. chemicalgutter says:

    Don't know why nobody is giving props to Siddhu.  The "Ctrl +" shortcut works way better for large inserts…

    Lets say you need to insert 700 rows:  You use "F4" to get you to 10 rows, then highlight and copy your ten rows and press "Ctrl +" 9 times (makes a total of 100 rows). Then highlight all 100 new rows and press "Ctrl +" 6 times.  Voila!! Now you have 700 rows without hitting F4 700 times.  

  22. lead says:

    Hey reynold that was really really aw! Thanks bud.

  23. Angela H. says:

    Another easy way to insert multiple rows: