how do I divide or multiply an entire column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a price list that I need to convert entire columns by either dividing
them or multipication. Is there a formula to do this.
 
Enter your multiplier in an unused cell, NOT in the column you're going to
multiply, then right-click on it and do Copy, then highlight the cells to be
multiplied and do .PasteSpecial, and check the Multiply box, then > OK

Vaya con Dios,
Chuck, CABGx3
 
When I do the .Paste Special all I see is Text and Unicode Text. Also when I
try to highlight the cells it changes them all to the same number.
 
How did you copy that cell?

Did you copy the contents from the formula bar or did you select the cell then
Edit|copy?

If you didn't use Edit|Copy (or rightclick copy or ctrl-c), then try it that
way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Split column data 0
Calculation of weighed average 6
Help - I've tried all kinds of things but no luck. 1
Formulas that include alpha and numeric characters 1
Calculating column A * column B = Results in another column 2
forecast a financial value at year end 1
How do I multiply either column 1 or column 2 by same multiplier? 2
Find text, then calculate 6

Back
Top