Newbie needs help with Works 6.0 spreadsheet

  Trikie 17:52 11 Feb 08

I have never even looked at the spreadsheet function but now need it and can't find answer in Help (probably there but I can't see where)

I need to build up instructions on a road route, showing intermediate and cumulative distances. I've seen a print of one that I want to copy.

Column A shows the intermediate distance and Column E the running total (B, C and D contain text directions). A1 is blank, being the start point so presumably E1 is entered manually. What is the formula for adding E1 to A2 and displaying it in E2 and so on for 30 columns?

  VoG II 17:59 11 Feb 08

In E1 enter the formula


Click in E1 and hover the cursor over the bottom right corner of the cell and the cursor will turn into a +

Hold down the left mouse button and drag the formula down as far as needed.

  Pineman100 18:26 11 Feb 08

VoG - my (cruder) solution would have been:

In E1 enter =A1

In E2 enter =E1+A2 (then replicate E2 down the column as you've described)

Yours is much more elegant - what function does the $ sign perform, please?

  johnnyrocker 18:31 11 Feb 08

fixed reference.


  VoG II 18:34 11 Feb 08

The $ makes A$1 an Absolute reference - when you drag the formula down the row number won't change. If you wrote $A$1 that would also 'fix' the column but that isn't necessary in this case.

  Pineman100 18:39 11 Feb 08

Gotcha. Thanks for that.

  Trikie 20:28 11 Feb 08

Thanks everyone - my entry into another new computer world.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…