Repeat formula

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
 
T

trip_to_tokyo

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.
 
F

FSt1

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
 
T

trip_to_tokyo

. . 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.
 
J

james

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
 

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

Top