Freigeben über

Insert multiple rows and columns quickly in Excel

  • Artikel

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.

Suzanne

Comments

  • Anonymous
    April 04, 2012
    is there some way to just say "insert 77 rows" instead of painstakingly selecting precisely 77 rows first?

  • Anonymous
    April 13, 2012
    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.

  • Anonymous
    September 07, 2012
    Thanks for useful information. Keep up the good work!

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

  • Anonymous
    October 10, 2012
    You indicate that the selected rows "must include the location".  How do they include the location?

  • Anonymous
    December 06, 2012
    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.

  • Anonymous
    February 01, 2013
    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: www.exceltrick.com/.../insert-multiple-rows-in-excel

  • Anonymous
    February 05, 2013
    Select multiple rows and press Ctrl +, this keyboard shortcut is a bit handy.

  • Anonymous
    February 21, 2013
    Thanks Siddhu..its working great!!!!

  • Anonymous
    March 17, 2013
    What is the mac equivalent for the f4 key?

  • Anonymous
    April 16, 2013
    This note is for Reynold Feb 2013 - you are my new BEF or Best Excel Friend.  I love this shortcut!!!!!!!!!!!!!!!!!!!!!!!!

  • Anonymous
    May 23, 2013
    Amen to that Waterworld!  REYNOLD is AWESOME!  That was great!  so sick of "Insert... Entire row... " blah blah.  YAY!  I'm free!!!!!!!!!!

  • Anonymous
    June 13, 2013
    Raynold you saved my life jajaja...thanks for the info.....it worked perfectly!!!!

  • Anonymous
    June 16, 2013
    i agree with Waterworld! Reynold- that is an amazing tip!

  • Anonymous
    June 20, 2013
    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. office.microsoft.com/.../insert-rows-columns-or-cells-HP005200926.aspx

  • Anonymous
    July 11, 2013
    helped out heaps thank u soooooooooooo much

  • Anonymous
    July 16, 2013
    The comment has been removed

  • Anonymous
    July 16, 2013
    Switch to the Mac version. You can insert copied rows etc as many times as you like without having to recopy each time.

  • Anonymous
    August 19, 2013
    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.

  • Anonymous
    September 18, 2013
    Reynold, You are awesome! Thank you for the tip!!!

  • Anonymous
    October 07, 2013
    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.  

  • Anonymous
    October 31, 2013
    Hey reynold that was really really aw! Thanks bud.

  • Anonymous
    November 11, 2013
    Another easy way to insert multiple rows: www.youtube.com/watch