EXCEL Formulae

  Furkin 09:31 15 Nov 08
Locked

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 08

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 08

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

all the best

Furkin

Resolved

  Noldi 11:30 15 Nov 08

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.

Noldi

  Furkin 14:27 15 Nov 08

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

Thanks for the info.

Furkin

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

Sniper Elite 4 review: Headshotting Nazis has never felt so good

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

The Best Design, Illustration, Animation and VFX Awards of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced