| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Formula Question - how to get formula to repeat in each subsequent row? | New Users to Excel | |||
| how to repeat the upper row formula without entry formula? | Excel Discussion (Misc queries) | |||
| Repeat formula on second sheet? | Excel Discussion (Misc queries) | |||
| How do you repeat a function in a formula | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Linear Mode
