How to Divide an Excel Column by 6 with a Formula in WPS Office
Question details
The user needs to calculate a monthly billing share for each row by dividing the value in column C by 6 and then apply that formula down the entire adjacent data range in WPS Office Spreadsheets.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Monthly billing totals are stored in column C, and each total must be split into six equal shares in column D.
- Observed behavior
- The user needs a formula in column D that divides each column C amount by 6 and fills down next to the existing data.
Open the workbook in WPS Office Spreadsheets, confirm the first total is in C2, and make sure column D is ready for the calculated shares. If there are blank data rows, the fill handle may stop at the blank, so check the adjacent data range first.
Use =C2/6 in WPS Spreadsheets and Fill Down with the Fill Handle
Use this formula method when your totals are in column C and you want each monthly share shown in column D.
The formula uses a relative reference to C2, so filling down automatically updates each row to =C3/6, =C4/6, and so on.
Click cell D2, or the cell directly beside the first total in column C.
Type =C2/6 and press Enter. WPS Office calculates the first monthly share.
Select D2 again, then double-click the fill handle at the lower-right corner of the cell to copy the formula down beside adjacent data.
Select column D, right-click and choose Format Cells. On the Number tab, select Number and set Decimal places to 3, then click OK.
Divide a Billing Column by 6 in WPS Office Spreadsheets
WPS Office Spreadsheets can directly divide the totals with =C2/6, fill the formula through the column with the fill handle, and maintain Microsoft Excel formula compatibility.
- 1. Open your workbook: Open the billing workbook in WPS Office Spreadsheets.
- 2. Enter the division formula: Click D2, type =C2/6, and press Enter.
- 3. Fill the formula down: Double-click the fill handle in D2 to copy the formula down beside column C.
- 4. Format the results: Select column D, right-click, choose Format Cells, and set Decimal places to 3.
Frequently Asked Questions
What formula divides a cell by 6 in WPS Office Spreadsheets?
Use =C2/6 if the total is in C2. Change the cell reference to match the first total in your column.
How do I copy the division formula down an entire column without dragging?
Select the formula cell, then double-click the fill handle at the lower-right corner. WPS fills down to the last adjacent data row.
Why does double-clicking the fill handle not fill down my whole column?
The fill handle fills only next to a continuous adjacent data range. Blank cells in column C can stop the fill, so select the formula cell and drag the fill handle manually to cover the remaining rows.
Can I show all divided results with three decimal places?
Yes. Select column D, right-click, choose Format Cells, select Number, set Decimal places to 3, and click OK.
Will this formula work when I open the file in Microsoft Excel?
Yes. The relative reference =C2/6 is standard Excel syntax, so WPS-created .xlsx files perform the same calculation in Microsoft Excel.
