paste a formula to a range of cells

[Doug Blaisdell]

hi all,

Excel newbie here--If I have a range of cells in a row, all with the
same formula (using relative cell addresses), and want to extend this
row another ten cells to the right say, using the same formula, how do
I do it. I've tried copying one cell, and pasting it these 10 cells
(after I've highlighted them) but that doesn't work.

thanks in advance

 

[Steve]

Doug:

That should work...Highlight the cell with the formula in
it (NOT a blank cell), hit CTRL-C, then highlight those 10
cells on the Right, and hit CTRL-V...This should do
it...Any questions, drop me an email...

Steve

 

[Debra Dalgleish]

What happens when you copy one cell and paste into the highlighted cells?

Another way to copy to the right is to use the fill handle --
Select the last cell that has a formula in it
Point to the fill handle (the small black square at the bottom
right of the cell)
When the pointer changes to a black plus sign, drag to the right
(you can also drag down, up or left, to copy in other directions)