repeating a formula throughout a worksheet

[jtnru]

Hi
I havent used excell for some years and have set up a basic worksheet, but
am wanting to repeat a formula each third row which is row 1 balance plus row
2 minus row 3 equals balance as displayed in row 4 and then repeat this
thoughtou the worksheet for several columns ( if that makes sense- im sure it
can be done not sure how thou and have looked through help topics everywhere
so if any one can help in basic language it would be great thanks.
Jtnru

 

[Simon Lloyd]

If its single row then click your cell that contains the formula once
then hold shift and click the further most cell that you want the
formula in then goto EDIT>FILL>RIGHT or did you want it repeating down
the sheet too?


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)

 

[Mikey]

Click & Hold left mouse button to select the WHOLE area you want to repeat
then release mouse button and hover over the bottom right corner of selected
until cursor turns to black cross rather than white then click & hold right
mouse button and drag to desired point.

All formula and data will be copied over, you can then delete just the data

 

[jtnru]

Yes i would like it to repeat down the worksheet as well.
Thanks

 

[The Code Cage Team]

Its a similar proceedure, start with your formula then highlight the
entire area you wish to have the formula copied over then goto
EDIT>FILL>DOWN then goto EDIT>FILL>RIGHT.

If its a little more complex than that then why not join our forums
where you can upload a workbook and we can help you further.


--
The Code Cage Team

Regards,
The Code Cage Team
www.thecodecage.com