Thread: Learn formulas
View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Kevin,
Not familiar with Lotus 1-2-3 or it's terminology. Perhaps the
equivalent in Excel is use of the fill handle.
http://www.mvps.org/dmcritchie/excel/fillhand.htm
also see inserting rows with a macro and extending formulas option
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Kevin Henderson" <Kevin wrote ...
Lotus could repeat a group of formulas like incremental rows. I think they
called it lean a formula so the program would repeat the incremental rows or
colums