I have an excel sheet with a huge column size. I want to work with a column (without copying to an empty column) and multiply all the entries in this column by 1000, replacing the previous entries. Any help is appreciated. Thank you
Here is the solution for you.
All you have to do is write the value in the cell, copy it, and then use the option paste special.
paste special
How to multiply range cells by number in Excel?
, , , - B1, , ( A2) , B1, $B $1 B1, B1 , , , , B1.
