Formating rows and columns

[Dave]

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.

 

[Bernard Liengme]

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