i need to repeat some cells and in that cells are some formulas
is there a function to repeat that cells and formula in them ?
on picture i did it manually but is there a formula to repeat something "n" times ?
http://img165.imageshack.us/my.php?i...4114486zq3.jpg
Last edited by cro4you.org; 06-30-2008 at 12:00 PM.
G'day,
Just to duplicate the formula and the spacing as well, to your example you supplied.
Highlight cells A25 to A29, then press the Ctrl button and copy down.
This should duplicate the formula(s) and the blank cells.
Hope this helps
Cheers
Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
Please don't forget to do the same to other contributors of this forum.
Thanks
I don't void confusion, I create it
the problem is "n" is variable
it can be 2 3 4 etc
i m trying to make calculations for civil engineers
so in large building engineer has to repeat something 15-25 times
so he can make failure so easy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks