ExcelBanter - Extention a formula to a new location

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Extention a formula to a new location (https://www.excelbanter.com/excel-discussion-misc-queries/194579-extention-formula-new-location.html)

aar

Extention a formula to a new location

how can I extend a formula to the few cells forward ( from f5 to
f6/f7/f8/f9/f10/f11)

Gord Dibben

Extention a formula to a new location

Drag the fill handle at lower right corner of F5 and copy the formula across.

You may need some combination of relative and absolute addresses but you don't
provide any detail.

Gord Dibben MS Excel MVP

On Fri, 11 Jul 2008 14:28:13 -0700, aar wrote:

how can I extend a formula to the few cells forward ( from f5 to
f6/f7/f8/f9/f10/f11)

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