[Solved] How to add a new row on alternating rows?

Discuss the spreadsheet application
Post Reply
ironfistx
Posts: 27
Joined: Wed Aug 23, 2017 11:06 pm

[Solved] How to add a new row on alternating rows?

Post by ironfistx »

I made a bunch of rows that I want to keep, but I want to add rows on every other row.

I tried highlighting with shift, adding new row, but that just put the exact amount of new rows in.

I tried highlighting with ctrl, adding new row, but that did the same.
Last edited by MrProgrammer on Wed Aug 12, 2020 5:29 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
openoffice 4 windows 10
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: how to add a new row on alternating rows?

Post by John_Ha »

No. You need to add them one by one. It only takes three clicks per row. Your post required 260 keystrokes, enough to enter over 80 rows.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
User avatar
MrProgrammer
Moderator
Posts: 4907
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: how to add a new row on alternating rows?

Post by MrProgrammer »

ironfistx wrote:I made a bunch of rows that I want to keep, but I want to add rows on every other row.
[Solved] Adding blank rows between rows

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: how to add a new row on alternating rows?

Post by John_Ha »

MrProgrammer wrote:[Solved] Adding blank rows between rows[/url]
Very neat trick - I should have thought of it.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Post Reply