Repeat formula

  • Thread starter Thread starter james
  • Start date Start date
J

james

Hi again, thanks for the help, im trying to repeat a formula for all cells in
a column, is there an easy way of doing this?
Thanks
James
 
EXCEL 2007

Ctrl-C in the cell where the formula is (to copy it)

Ctrl-V in cell(s) to which you wish to copy said formula.

If my comments have helped please hit Yes.

Thanks.
 
hi
another way.
select the cell with the formula.
place the mouse on the lower right corner of the cell with the formula
the curser will change to a Plus symbol.
click and hold the left mouse button and drag down as far as needed.
release the mouse button.

regards
FSt1
 
. . or is this what you want:-

- click on letter at top of column to highlight whole column

- right click / Copy

- go to destination column / highlight whole column again by clicking in
column header letter then right click and Paste.
 
Thanks alot, works a treat!

FSt1 said:
hi
another way.
select the cell with the formula.
place the mouse on the lower right corner of the cell with the formula
the curser will change to a Plus symbol.
click and hold the left mouse button and drag down as far as needed.
release the mouse button.

regards
FSt1
Click to expand...
 
Back
Top