Copying Formulas to rows

M

mdj101

Hi All,

I have created a book which has various formulas accross a row which
are all worked out from figures in that row.

But I cant figure how to make the whole sheet use these forumlas, i.e.
when i start typing info on row 2 it uses the same formulas as on row
1.

The only way I have worked out so far to do this is to copy and paste
each row, but this is time consuming and im sure there must be a
quicker way?

Thanks in advance for your help.
 
M

mdj101

Thats great,

Just what i needed, thanks.

One other question though.

One of my formulas uses a percentage. as a disocunt for example.

cost price £100 - 25% what i have done is put the 25% in its own cel
as the value 1.25 and used the following fomula.

=SUM(G7*(1/K1)) where K1 is the cell of the percentile. I want to b
able to change the whole work sheet by just changing this cell but whe
i copy the formula it increases the K1 number to the next row. How can
avoid this
 
B

BruceP

You can use an absolute cell reference - $K$1, instead of K1.
Alternatively, you can name cell K1 (something like "Discount"), then
refer to that name in your formula.
 
B

Bryan Hessey

Use K$1 $K1 or $K$1 to prevent the incrementing change when dragging
horizontally, vertically, or either way.

The site http://www.mvps.org/dmcritchie/excel/formula.htm states:

-Converting Formula to/from absolute with F4 (#absolute)
With the cursor on part of a formula displayed on the formula bar, F4
will change relative to the absolute (A1, $A$1, A$1, $A1). -

--
 
Top