Ask Your Question

automatically insert rows in a calc spreadsheet

asked 2019-07-23 02:29:19 +0100

Shaba1 gravatar image

updated 2019-07-25 03:57:40 +0100

I have a sheet that has product name, metric weight, decimal pounds, pounds. ounces, price, sales tax, shipping. All those columns are in one row for each product. and there is a sum cell for each column at that bottom of the sheet.

This is going to be a continuous sheet, meaning that there will be rows always entered into it as I add products. Is there a way to automatically insert new rows after I press enter in the shipping cell? The inserted row would go to the row above the row that has the sums for each column. So that I do not have to manually insert every time.? Or is this something better down in BASE?

edit retag flag offensive close merge delete


I have two requests. 1 Edit your post and correct all the typos, difficult for me to understand. Two, could you post a screenshot of this spreadsheet?

lazarus477 gravatar imagelazarus477 ( 2019-07-23 02:35:16 +0100 )edit

Will you use more that 1 million rows in this spreadsheet?

Why not put the totals in the top row? Then you wont have to add rows? Better yet... us a pivot table to do the totaling for you on another sheet tab.

AdmFubar gravatar imageAdmFubar ( 2019-07-23 04:37:27 +0100 )edit

Hey now those were some very good ideas! I suggest you proof read your text, got some typos in there.

lazarus477 gravatar imagelazarus477 ( 2019-07-28 02:58:08 +0100 )edit

3 Answers

Sort by » oldest newest most voted

answered 2019-07-25 04:45:44 +0100

@Shaba1, Here's a suggestion.

Click Insert Lines Button and fill.

Test file.


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more


I downloaded the test file and everytime I click on that button nothing happens.

Shaba1 gravatar imageShaba1 ( 2019-07-29 01:17:50 +0100 )edit

@Shaba1, in Win10 + LibO

The 2 working.

Test file.

Test file2,

Schiavinatto gravatar imageSchiavinatto ( 2019-07-29 02:46:19 +0100 )edit

answered 2019-07-25 04:42:52 +0100

Shaba1 gravatar image

updated 2019-07-25 04:44:07 +0100

Here is a screenshot. I have not added all of the columns yet. The sum row is that next to the last one you see in the screenshot. This is going to be a long list so I am anticipating having to add new rows as I add products. The sheet IS NOT relational. There is no data from other tables nor will there be in future.

image description

edit flag offensive delete link more


I noticed that there are formulas in the line .. Fill in line 2 and click on the Save button.

Test file2,

Schiavinatto gravatar imageSchiavinatto ( 2019-07-25 05:10:41 +0100 )edit

answered 2019-07-23 02:45:14 +0100

lazarus477 gravatar image

updated 2019-07-28 01:57:07 +0100

I think what you are looking for is Insert Rows.

  1. Select the row for Sum, by pressing the row number to the left most edge of the sheet.
  2. Right click on mouse on the selected row.
  3. Choose Insert Rows->Above.

This will add one row at a time.

To insert multiple rows in one go:

  1. Select a series of rows by pressing down on row number (left edge) and dragging the mouse cursor down or up.
  2. Right click as before on the selection and choose Insert Rows->Bellow.

This will add a number of new rows equal to the number you had selected.

Does this answer your question?

edit flag offensive delete link more


I know I can do that buy using INSERT ROWS---> Above. That was not the question. My question was if there was a way or a macro so that when I hit return in the last column of a row that ANOTHER ROW right above the sum row would be inserted AUTOMATICALLY.

Shaba1 gravatar imageShaba1 ( 2019-07-29 01:16:45 +0100 )edit

As far as I know, no such macro exists. But that is not to say that you cannot create such a macro. A practical solution is to either use the method described in my answer. An alternative solution is to place the Sum at the top most row. It is also possible to have sums on a separate sheet.

lazarus477 gravatar imagelazarus477 ( 2019-08-06 09:06:58 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-07-23 02:29:19 +0100

Seen: 284 times

Last updated: Jul 28