How do you formulate an entire column?
 

I need to multiply all the numbers in a column by 8.25%. How do you do that?
--
SW

How do you formulate an entire column?
 

If you want to keep the original data and have the results in a
new column, just insert a new column and use the formula

=A1*0.0825

and copy down as far as you need to go. Change the 'A1' to your
first cell.

If you want to replace the existing data, enter 0.0825 in some
empty cell, copy that cell, select your numbers, then go to the
Edit menu, choose Paste Special, select the Multiply option, and
click OK.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"SWcoord" wrote in message
...
I need to multiply all the numbers in a column by 8.25%. How do
you do that?
--
SW