Calculation Issues

How to Increase Excel Column Values by 8 Percent in WPS Office Spreadsheets

Nimra MalikNimra Malik Nov 13, 2026 870 views

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.

How to Increase Excel Column Values by 8 Percent in WPS Office Spreadsheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the first updated value cell

Click the cell immediately to the right of the first original amount. If the first monthly fee is in A2, select B2.

2
Enter the 8% increase formula

Type =A2*1.08 and press Enter. B2 now displays the original amount increased by 8 percent.

3
Fill the formula down the column

Click B2, then drag the fill handle down through the last client fee row to apply the calculation to the full column.

4
Convert the results to plain values

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.

Calculate an 8% increase with a helper-column formula
Updated values are ready: The helper column now contains plain values only, so it can be exported or reimported into the debit-order system without formula links.
WPS Office Spreadsheets solution

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. 1. Open your fee workbook: Launch WPS Office Spreadsheets and open the .xlsx workbook that contains the monthly client fees.
  2. 2. Apply the 8% formula: Click the first helper cell, enter =A2*1.08, and fill the formula down the updated fee column.
  3. 3. Convert to reimport-ready values: Copy the updated column, click Home > Paste Special > Values, and save the workbook for the debit-order system.
Handles percentage increases across a full column without manual recalculationReads, edits, and saves Microsoft Excel .xlsx files for smooth compatibilityFree to use, lightweight, and familiar for spreadsheet users moving from ExcelPrepares plain value columns ready for external debit-order system imports
microsoft office alternative - wps office

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.