View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.