Excel help please!

  Lokit 08:57 20 Jul 05

The workbook consists of a list of items sometimes 50 items long.

Column 1 - Gross per item

Columns 2 to 9 - Various expenses

Column 10 - Nett per item

I can easily calculate the nett using formula :

Column 1 minus Sum(2:9)

But this is a lengthy process doing each row individually.

How can I apply this argument to the whole workbook?

Thanks in advance.

How can I apply this argument to the whole workbook

  seedie 09:04 20 Jul 05

Do the first one in column 10 by hand and press enter. put the mouse on that cell with the pointer on the bottom right hand corner press the left mouse button and drag it down as far as you want to go.

  Lokit 09:46 20 Jul 05

Many thanks my friend!

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

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch