Prev: cell selection troubleshooting
Next: Microsoft Excel
From: james on 19 Apr 2010 15:28
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

From: trip_to_tokyo on 19 Apr 2010 15:33
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
>
From: FSt1 on 19 Apr 2010 15:37
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
>
From: trip_to_tokyo on 19 Apr 2010 15:42
. . 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
>
From: james on 19 Apr 2010 15:43
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
> >
 | 
Pages: 1
Prev: cell selection troubleshooting
Next: Microsoft Excel