Insert multiple rows and columns quickly in Excel

Insert multiple rows and columns quickly in Excel

  • Comments 23
  • Likes

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
  • is there some way to just say "insert 77 rows" instead of painstakingly selecting precisely 77 rows first?

  • 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.

  • Thanks for useful information. Keep up the good work!

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

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

  • 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.

  • 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

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

  • Thanks Siddhu..its working great!!!!

  • What is the mac equivalent for the f4 key?

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

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

  • Raynold you saved my life jajaja...thanks for the info.....it worked perfectly!!!!

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

  • 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

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment