How To Insert Multiple Rows In Excel For Mac

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.

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Currently, I copy a row, right click and choose insert copied cells. This works great but only works for copying one row below. What if I want to copy 2 or 3 rows below?

I can find blank rows, copy them, and insert them and then do this, but that is real tedious. I wish there was a was to simply copy a row and hit some keystroke which would copy that row right below as many time as you click the keystroke.

Does this exist? Phillip Jones, C.E.T. 24/4/2010, 12:25 น.

Phillip: that does not work for rows. And as you know, inserting blocks of cells leads to potential disaster as some columns but not others get their existing cells moved down. The problem is that Excel does not allow you to repeat the 'insert copied row(s)' action. It's a foolish deficiency. All I can recommend is to start by selecting N rows at your intended insertion point, commanding 'Insert rows,' which will give you a bunch of new blank rows, then Copy/Pasting the cells in the original source row.

In article, 'Phillip Jones, C.E.T.' Wrote: > Sorry left out a step or two: > > 1. Click in first cell desired > 2. Shift click in last cell wanted > 3. Command-c to copy. (Can paste to another Spreadsheet if you desire) > 4. Select cell of desired location, Click.

Command-V for Paste. > > wrote: > > Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: > > Intel Currently, I copy a row, right click and choose insert copied cells. > > This works great but only works for copying one row below.

> > > > What if I want to copy 2 or 3 rows below? > > > > I can find blank rows, copy them, and insert them and then do this, but > > that is real tedious. > > > > I wish there was a was to simply copy a row and hit some keystroke which > > would copy that row right below as many time as you click the keystroke. > > Does this exist? -- Team EM to the rescue! Kev.@officeformac.com 24/4/2010, 16:03 น. Thanks Carl you are correct.

With Phillips method you delete the row you select to copy to. Actually I wish it would push down that target row, but it does not seem to, it just seems to delete it.

I know the insert row trick, but the problem is what if I have a workboork with 5000 rows? It's a real hassle to scroll all the way to the bottom just to get some blank rows. Although I'm not sure I understood your solution: 'selecting N rows at your intended insertion point, commanding 'Insert rows,' which will give you a bunch of new blank rows, then Copy/Pasting the cells in the original source row.' Did not understand: N rows, what does that mean select N rows?

You mean select blank rows from bottom of the page right? Also, how do you dismiss the clipboard which comes up and blocks cells from view? Carl Witthoft 25/4/2010, 8:41 น. In article, wrote: > Thanks Carl you are correct. > With Phillips method you delete the row you select to copy to. Actually I > wish it would push down that target row, but it does not seem to, it just > seems to delete it. I know the insert row trick, but the > problem is what if I have a workboork with 5000 rows?

It's a real hassle to > scroll all the way to the bottom just to get some blank rows. > Although I'm not sure I understood your solution: > 'selecting N rows at your intended > insertion point, commanding 'Insert rows,' which will give you a > bunch > of new blank rows, then Copy/Pasting the cells in the original source > row.' Did not understand: N rows, what does that mean select N > rows?

> You mean select blank rows from bottom of the page right? Also, how > do you dismiss the clipboard which comes up and blocks cells from view? Not that hard:-).

What I meant was: suppose you want to insert row 12 seven times just below row 30. Then select rows 31 thru 37, and grab the menu item that says 'Insert rows.' That should create 7 new blank rows between the original rows 30 and 31. Then you can copy / paste the block of cells in row 12 into the new blank rows. So far as that ^@#($*!@%$^ 'helpful' clipboard floater, I believe you can right-click it (cmd-click) and select some option not to have it appear.