EXCEL Formulae

  Furkin 09:31 15 Nov 2008

Can I COPY the 'formula' from one square to several others ?

For eg: on line 5 I can add up 5a, 5c, 5e, 5g by using the simple "?+?+?+?" formula in sq 5K.

I also want to use the same formula on multiple lines,,,,, so would think that I can copy the formula in 5K to 5K, 7K, 8K, etc etc etc to save writing it out on hundreds of lines.

thanks folks

  VoG II 09:38 15 Nov 2008

You can use the fill handle. Click in the cell containing the formula that you want to copy then hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down or across as required.

See click here and click here

  Furkin 10:45 15 Nov 2008

thanks once again VoG:
I was sure it was available,,,,, but needed someone to show me where/how.

all the best



  Noldi 11:30 15 Nov 2008

Paste special is a handy one to remember when copying certain thing around in Excel once you have copied a cell right click the new cell and paste special > Formulas, Formats, Values etc.


  Furkin 14:27 15 Nov 2008

,,,,, thanks Noldi,,,,, I have never used paste special - so will have a look at it.

Thanks for the info.


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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?