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

Discuss the spreadsheet application

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

Postby ironfistx » Wed Aug 05, 2020 5:38 am

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
ironfistx
 
Posts: 27
Joined: Wed Aug 23, 2017 11:06 pm

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

Postby John_Ha » Wed Aug 05, 2020 12:30 pm

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.
John_Ha
Volunteer
 
Posts: 8206
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby MrProgrammer » Wed Aug 05, 2020 3:56 pm

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 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3904
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

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

Postby John_Ha » Wed Aug 05, 2020 6:00 pm

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.
John_Ha
Volunteer
 
Posts: 8206
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests