Excel help please!

  Lokit 08:57 20 Jul 2005

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 2005

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 2005

Many thanks my friend!

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

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?