Question About Formula for 1 column
 

I am creating a database that generates an estimate of materials and labor
with a total estimated price. I am on 1 worksheet where I want to write a
formula for a column. =G2*H2+(I2)-(J2) is the cell formula but I need it to
be in the whole column. It takes the dimensions entered in "G" and "H" then
adds or subtracts from the square footage. Is it possible to make this do
the whole column without typing out each cell in that column? I am fairly
new to this.

Question About Formula for 1 column
 

Enter the formula in one of the cells in the column. Then highlight that
cell and choose Edit / Copy from the menu path. Then highlight the entire
column and choose Edit / Paste from the menu path. Basically you can copy
the formula to any cell and it will read the proper cells in each row (since
you don't have "$" in your formula). Also be careful about using parenthesis
in your formula so that the multiplication, addition, and subtraction is done
in the order that you want it to.

Hope that helps.

Bill Horton

"FearFactory510" wrote:

I am creating a database that generates an estimate of materials and labor
with a total estimated price. I am on 1 worksheet where I want to write a
formula for a column. =G2*H2+(I2)-(J2) is the cell formula but I need it to
be in the whole column. It takes the dimensions entered in "G" and "H" then
adds or subtracts from the square footage. Is it possible to make this do
the whole column without typing out each cell in that column? I am fairly
new to this.

Question About Formula for 1 column
 

If you mean that you want the formula to appear in many cells within the
column, then simply
1) select the cell with the formula,
2) either press Ctrl-C or use the menu to choose Edit-Copy
3) select the cells where you want the formula to be
4) either press Ctrl-V or use the menu to choose Edit-paste


"FearFactory510" wrote:

I am creating a database that generates an estimate of materials and labor
with a total estimated price. I am on 1 worksheet where I want to write a
formula for a column. =G2*H2+(I2)-(J2) is the cell formula but I need it to
be in the whole column. It takes the dimensions entered in "G" and "H" then
adds or subtracts from the square footage. Is it possible to make this do
the whole column without typing out each cell in that column? I am fairly
new to this.