I have an excel sheet with huge column size. I want to operate upon the column (no copying to a blank column) and multiply all the entries in that column by 1000, replacing the previous entries. Any help is appreciated. Thanks.
我有一个巨大的柱子大小的excel表。我想对列进行操作（不复制到空白列）并将该列中的所有条目乘以1000，替换之前的条目。任何帮助表示赞赏。谢谢。
2 个解决方案
#1
7
Here is the solution for you.
这是您的解决方案。
All you need to do is write a value in a cell, copy that and then use paste special option.
您需要做的就是在单元格中写入一个值，复制该值然后使用粘贴特殊选项。
How to multiply a range cells by a number in Excel?
如何在Excel中将范围单元格乘以一个数字？
#2
4
you can put the number that you need to multiply for in an other cell, for example in the image is B1, then create an other column multiplying the first number (image is A2) by the one in B1, but put the formula with $B$1 instead of B1, that will keep B1 value static, then drag the formula down and that is it, a new column with all entries multiplied by B1.
你可以把你需要的数字加到另一个单元格中，例如在图像中是B1，然后创建另一列，将第一个数字（图像是A2）乘以B1中的一个，但是将公式放在$中B $ 1而不是B1，这将使B1值保持静态，然后向下拖动公式，即一个新列，所有条目乘以B1。
#1
7
Here is the solution for you.
这是您的解决方案。
All you need to do is write a value in a cell, copy that and then use paste special option.
您需要做的就是在单元格中写入一个值，复制该值然后使用粘贴特殊选项。
How to multiply a range cells by a number in Excel?
如何在Excel中将范围单元格乘以一个数字？
#2
4
you can put the number that you need to multiply for in an other cell, for example in the image is B1, then create an other column multiplying the first number (image is A2) by the one in B1, but put the formula with $B$1 instead of B1, that will keep B1 value static, then drag the formula down and that is it, a new column with all entries multiplied by B1.
你可以把你需要的数字加到另一个单元格中，例如在图像中是B1，然后创建另一列，将第一个数字（图像是A2）乘以B1中的一个，但是将公式放在$中B $ 1而不是B1，这将使B1值保持静态，然后向下拖动公式，即一个新列，所有条目乘以B1。