Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
HELP FORMATING COLUMNS | Excel Discussion (Misc queries) | |||
conditional formating of group of columns and rows | Excel Worksheet Functions | |||
Formating columns | Excel Discussion (Misc queries) |