Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 8th 08, 07:43 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 2
Default 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   Report Post  
Old November 8th 08, 12:42 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default 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   Report Post  
Old November 8th 08, 02:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 38
Default 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   Report Post  
Old November 9th 08, 11:43 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 2
Default 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   Report Post  
Old November 9th 08, 10:04 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeating information throughout a worksheet kimmie Excel Discussion (Misc queries) 4 September 9th 08 11:33 PM
How do I get rid of repeating columns in a MS Excel worksheet? Connect Excel Discussion (Misc queries) 2 June 30th 08 07:22 PM
creating repeating headers in a worksheet larinoz Excel Discussion (Misc queries) 3 July 12th 07 08:58 PM
Repeating a Macro For Each Selected Worksheet carl Excel Worksheet Functions 0 January 11th 06 11:07 PM
how to stop repeating a number in worksheet(e.g. cell A1 is 6655 . Mushtaque Parker Excel Discussion (Misc queries) 0 April 24th 05 01:04 PM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017