How to Increase Excel Column Values by 8 Percent in WPS Office Spreadsheets
Question details
The user needs to calculate an 8 percent increase for a column of monthly client fees and prepare the updated values for reimporting into a debit-order system.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user manages monthly client fees in a spreadsheet and needs to raise every fee by 8 percent for a debit-order import workflow.
- Observed behavior
- The existing fee column shows the original amounts; the updated 8-percent-increased values are not yet calculated in a reusable, import-ready form.
Open the WPS Office spreadsheet that contains the monthly client fees. Confirm which column holds the original amounts, and leave an adjacent empty column available for the updated values.
Calculate an 8% increase with a helper-column formula
Best when you need to keep the original client fees visible and produce a clean updated column for export.
The formula =A2*1.08 multiplies the original amount by 1.08, which represents 100 percent of the original value plus an 8 percent increase.
Using a helper column avoids overwriting source data until the updated values have been checked.
Click the cell immediately to the right of the first original amount. If the first monthly fee is in A2, select B2.
Type =A2*1.08 and press Enter. B2 now displays the original amount increased by 8 percent.
Click B2, then drag the fill handle down through the last client fee row to apply the calculation to the full column.
Select the updated column, press Ctrl+C to copy, then go to Home > Paste > Paste Special > Values to replace the formulas with reimport-ready values.

Increase the original values in place with Paste Special Multiply
Use this if you want to overwrite the original fee column directly and do not need a separate calculation column.
Increase monthly client fees by 8% in WPS Office Spreadsheets
WPS Office Spreadsheets gives you two practical ways to raise a column of values by 8 percent: a helper-column formula or Paste Special Multiply. Both produce import-ready values for your debit-order workflow while keeping Excel-compatible .xlsx editing.
- 1. Open your fee workbook: Launch WPS Office Spreadsheets and open the .xlsx workbook that contains the monthly client fees.
- 2. Apply the 8% formula: Click the first helper cell, enter =A2*1.08, and fill the formula down the updated fee column.
- 3. Convert to reimport-ready values: Copy the updated column, click Home > Paste Special > Values, and save the workbook for the debit-order system.

Frequently Asked Questions
How do I increase a whole column by 8 percent without creating a new column?
Copy a cell containing 1.08, select the original fee range, open Paste Special, choose Multiply, and click OK. This overwrites the original values, so work on a copy of the sheet if you need to keep the original figures.
Why use =A2*1.08 instead of =A2*8%+A2?
Both formulas are mathematically equivalent, but =A2*1.08 is shorter and easier to fill down. The multiplier 1.08 includes the original 100% plus the 8% increase.
How do I replace formulas with values for reimporting into debit-order software?
Select the formula result column, copy it, and then use Paste Special > Values to replace the formulas with plain values so the external system imports the updated amounts correctly.
Does WPS Office Spreadsheets support Excel .xlsx files?
Yes, WPS Office Spreadsheets opens, edits, and saves .xlsx workbooks, so you can maintain compatibility with Microsoft Excel and export updated values for external systems.




