Help with MotoGP spreadsheet

Discuss the spreadsheet application

Help with MotoGP spreadsheet

Postby Tonyb123 » Tue Mar 17, 2015 9:29 pm

Hi, I am a complete novice so please be patient with me! I have just purchased and downloaded a spreadsheet that enables me to add results to the MotoGP bike season as and when they race. The spreadsheet is a number of sheets long with a dashboard, team standings, Driver standings, race results and team/rider table. It already has riders and teams written into it for this year, but I need to add more riders. There are no more active cells left under the present riders, how do I set up additional cells so that it will change tables weekly with results.

Thank you
OpenOffice 4.1.1
Windows 7
Tonyb123
 
Posts: 1
Joined: Tue Mar 17, 2015 9:17 pm

Re: Help with MotoGP spreadsheet

Postby Lupp » Tue Mar 17, 2015 10:29 pm

Try inserting rows above the "Last Active Row: Select the LRA clicking on the numbered label to the left, rightclick, select option ..., insert, (repeat if needed; will work for more than one row at a time, too).
Select the row above the inserted range and fill formulae (if any) down. You may have to do related and similar steps on more than one sheets. Without seeing the sheets I cannot go into more detail.
On Windows 10: LibreOffice 6.1 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Let's create a powerful UFO: United Free Office!
Lupp from München
User avatar
Lupp
Volunteer
 
Posts: 2269
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany


Return to Calc

Who is online

Users browsing this forum: robleyd and 59 guests