Put 2 in an empty cell
copy that cell
select your range
edit|paste special|multiply
clean up that 2 in that cell.
Robert wrote:
In excel I have four columns all containing 500 cells. These cells represent
wholsale pricing. I want to muliply each column by 2 so they represent
retail pricing.
Robert
--
Dave Peterson
|