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
Click to expand...
 

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

How to make repeating drop-down lists? 2
Skipping the first row in a repeated header 0
Repeated phrases wildcard? 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Removing a repeated words 0
How to open multiple instances of Word 365? 5
Copy addition formula of non-consecutive horizontal cells 2
Newbie Help - IF Yes No Function 0

Top