Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
repeating a formula throughout a worksheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
repeating a formula throughout a worksheet
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 EDITFILLRIGHT or did you want it repeating down the sheet too? -- Simon Lloyd Regards, Simon Lloyd 'www.thecodecage.com' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26928 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
repeating a formula throughout a worksheet
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" wrote: 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
repeating a formula throughout a worksheet
Yes i would like it to repeat down the worksheet as well.
Thanks "Simon Lloyd" wrote: 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 EDITFILLRIGHT or did you want it repeating down the sheet too? -- Simon Lloyd Regards, Simon Lloyd 'www.thecodecage.com' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26928 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
repeating a formula throughout a worksheet
Its a similar proceedure, start with your formula then highlight the entire area you wish to have the formula copied over then goto EDITFILLDOWN then goto EDITFILLRIGHT. 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 ------------------------------------------------------------------------ The Code Cage Team's Profile: http://www.thecodecage.com/forumz/member.php?userid=2 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26928 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repeating information throughout a worksheet | Excel Discussion (Misc queries) | |||
How do I get rid of repeating columns in a MS Excel worksheet? | Excel Discussion (Misc queries) | |||
creating repeating headers in a worksheet | Excel Discussion (Misc queries) | |||
Repeating a Macro For Each Selected Worksheet | Excel Worksheet Functions | |||
how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . | Excel Discussion (Misc queries) |