Ask Your Question
1

Inserting rows in a spreadsheet

asked 2012-02-27 14:11:54 +0100

bkalaska gravatar image

Hi: Is there a way to insert many rows in a spreadsheet without doing it manually, one row at a time.I have to insert 2 rows at every other row 400 times. I can do it with a macro but still have to insert manually the first time. Thanks, Bill

edit retag flag offensive close merge delete

Comments

Select the bunch of cells that how much you wanted the number of cells to be inserted.. Copy it. Then Ctrl+Shift+V(Paste Special option). Suddenly Paste Special Dialog box popped up. In That dialogue box,at the bottom Shift cells option,select down and then click ok. you will get doubled with same formatting cells. Try it!

Mr Adventure gravatar imageMr Adventure ( 2018-10-01 20:40:05 +0100 )edit

4 Answers

Sort by » oldest newest most voted
3

answered 2012-02-27 21:44:15 +0100

MegaTallDave gravatar image

I don't know a direct way, but there may be a way to work around the problem.

You could number your data rows, and have a 2 rows of otherwise blank rows that started with those same numbers. Then sort by the column with those numbers and the blank rows will be interspersed.

Alternately, if you are extending a pattern, one idea that people commonly overlook is to have a blank as part of that pattern.

If you highlight a calculation and a blank and extend that pattern, then Calc will alternate between a doing a calculation and then skipping a cell.

edit flag offensive delete link more
2

answered 2012-11-01 17:23:45 +0100

jkcunningham gravatar image

Select a number of consecutive blank rows. Right-click on in the row-number part of the selection Select "Insert Rows".

It will insert the same number of rows you have selected.

edit flag offensive delete link more

Comments

Yes, works very well – thx! And it doesn't matter (luckily) that there is already data in the consecutive rows that you select. It will not affect this data, only increase the number of empty rows.

Annacondan gravatar imageAnnacondan ( 2015-12-18 21:19:44 +0100 )edit
0

answered 2015-03-19 18:40:55 +0100

yanpas gravatar image

There is much easier way! To insert multiple rows into a Calc spreadsheet at one time, select the same number of rows as you want to add, beginning at the row AFTER where you want the insertion to be, then Ctrl-click/right-click on the row header (where the row numbers are) within your selection, and choose Insert Rows from the contextual menu, or Click on the “Insert Rows” button in your toolbar (if it’s visible there), or Choose Rows from the Insert menu. To insert multiple columns, just follow the above instructions subtituting ‘columns’ for ‘rows’ – it works exactly the same way.

edit flag offensive delete link more
0

answered 2012-11-01 23:33:41 +0100

m.a.riosv gravatar image

updated 2012-11-01 23:34:00 +0100

You can activate in the formatting rule the icons for insert/delete rows/columns. Selecting several cells clicking the icon, do the job.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2012-02-27 14:11:54 +0100

Seen: 19,594 times

Last updated: Mar 19 '15