Formating rows and columns
 

Is there an easier way to format columns, to total 4 columns over a 30 row
span?
I need to create a cost tracking system to analyze cost vs: budget over a 30
day period containing four items; Material, Labor, Equipment, and
Contingency. Having to format the" total" columns for each row is very time
consuming.

Formating rows and columns
 

You have four columns of numbers
Lets say the first row is B2,C2,D2 and E2
In F2 type =SUM(B2:E2) or use the AutoSum tool (Greek symbol bit like E)
Click on F2 and look in its lower right corner - small black square is
called "fill handle"
Either drag this down the column or double click it to fill the other cells
in F with the formula
You are using formulas; nothing to do with format (means to change
appearance like bold or green, or showing more decimals....)
Without wishing to be rude: maybe you should get "Excel for Dummies" to
learn the basics
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Dave" wrote in message
...
Is there an easier way to format columns, to total 4 columns over a 30 row
span?
I need to create a cost tracking system to analyze cost vs: budget over a
30
day period containing four items; Material, Labor, Equipment, and
Contingency. Having to format the" total" columns for each row is very
time
consuming.