Formating rows and columns

  • Thread starter Thread starter Dave
  • Start date Start date
D

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.
 
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
 
Back
Top