Multiple a column of costs by a single factor
Try this:
Enter your multiplier in an empty cell.
Copy that cell
Select the range of cells to multiply
Then do EditPaste SpecialMultiplyOK
Biff
"RLR" wrote in message
...
I have a spread sheet of repair cost for 34 different plan types, each
column
is a different plan type of home with repair costs for that plan type in
each
column. I want to multiple each column by the number of homes in each of
the
plan types. I don't want to enter a formula in each cell of the column
(total
of 225 costs per column). There must be a simpler way. Using Excel 2003.
|