Multiple a column of costs by a single factor
You're welcome. Thanks for the feedback!
Biff
"RLR" wrote in message
...
Thanks, learned something new.
"T. Valko" wrote:
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.
|