ExcelBanter - How do I add a formula to a range of cells

1) You can type a formula into a cell and then drag the that cell's fill
handle (solid square in lower right corner) to fill other cells with the
formula. You need to know about absolute and relative referencing - see Help

I the cell is part of a vertical table, double clicking the fill handle is
quicker than dragging it.

2) You can select a range of cell, type the formula and finish off with
CTRL+ENTER. This fills the selected range with the same formula - with
appropriate cell reference changes.

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"wotnow" wrote in message
...