If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Repeat formula
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 |
#2
|
|||
|
|||
Repeat formula
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. "james" wrote: 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 |
#3
|
|||
|
|||
Repeat formula
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 "james" wrote: 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 |
#4
|
|||
|
|||
Repeat formula
. . 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. "james" wrote: 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 |
#5
|
|||
|
|||
Repeat formula
Thanks alot, works a treat!
"FSt1" wrote: 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 "james" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|