How to multiply a column of numbers by 2 in Excel

How to multiply a column of numbers by 2 in excel

Recommended tutorial: excel tutorial

1. Turn on the computer, find and double-click to open the excel2016 form software;

2. After double-clicking to open the excel form, edit column A first for demonstration Any numerical content;

#3. After editing, enter the number 2 that needs to be multiplied in any cell, and right-click the mouse to select the copy command;

4. After copying, right-click the cell in column A and select the "Paste Special" command option;

5. In the pop-up dialog box, click Multiply and confirm to multiply column A;

6. After setting and confirming, if you want to get For integers, right-click the cell in column A and click the "Format Cells" command;

7. Click the value in the pop-up dialog box, and click the small The number of digits is set to 0;

#8. After setting and confirming, the calculated value has been successfully rounded to an integer.

The above is the detailed content of How to multiply a column of numbers by 2 in Excel. For more information, please follow other related articles on the PHP Chinese website!