How do I add a formula to a range of cells

  • Thread starter Bernard Liengme
  • Start date
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
dragging formulas acros adjacent cells 3
Autofill a dynamic range with a formula. 1
The sum of the same function that is used for a range of cells 2
how to get a range of cells rounded off to the nearest value? 3
formula to compare a values and return 2
Dragging a formula in a column 1
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top