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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…