Excel help please!

  Lokit 08:57 20 Jul 05
Locked

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.

Intel Coffee Lake 8th-gen Core processors release date rumours

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

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009