How do you formulate an entire column?

C

Chip Pearson

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
 
Top