|
| 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
April 19th, 2010, 08:28 PM
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
April 19th, 2010, 08:33 PM
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
April 19th, 2010, 08:37 PM
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
April 19th, 2010, 08:42 PM
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
April 19th, 2010, 08:43 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
