how can I extend a formula to the few cells forward ( from f5 to f6/f7/f8/f9/f10/f11)
A aar Jul 11, 2008 #1 how can I extend a formula to the few cells forward ( from f5 to f6/f7/f8/f9/f10/f11)
G Gord Dibben Jul 12, 2008 #2 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
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
