How to divide a column by a fixed value in excel?

Method: First open the excel table, enter the equal sign in column C, then click A1 with the mouse (column A is the data column), then enter the division sign "/", then enter the divisor after the division sign, and press Press enter to get the result, and finally drag down the mouse to complete the division of all values.

Method:

1 Manually enter the divisor method. We save the results in column C, the same below. Enter the equal sign in column C, then click A1 with the mouse, enter the division sign "/", then enter the value "2" after the division sign, press the enter key to get the result, and then use the pull-down method to complete the division of all values.

2 Use fixed symbols. Enter the symbol "&" to fix the divisor position, and then use the drop-down method to get the final result.

3 Fill column C with the same value, and then use the drop-down method. As shown in the picture, fill column C with 2, then enter the formula and pull down.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to divide a column by a fixed value in excel?. For more information, please follow other related articles on the PHP Chinese website!