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.

You can format as cell as currency, put the number you want, copy that cell,
select all numbers that need to be multiplied and do editpaste special and
select multiply. Note that as opposed using help columns and formulas there
will not be any auditing traces so if you use the wrong number you can't
correct it by changing a formula, you need to know what the error was to
correct it



--
Regards,

Peo Sjoblom



"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.

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.

Thanks, that worked

"Peo Sjoblom" wrote:

You can format as cell as currency, put the number you want, copy that cell,
select all numbers that need to be multiplied and do editpaste special and
select multiply. Note that as opposed using help columns and formulas there
will not be any auditing traces so if you use the wrong number you can't
correct it by changing a formula, you need to know what the error was to
correct it



--
Regards,

Peo Sjoblom



"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.

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.

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.