WPS Spreadsheet: Change a Cell Formula and Rename a Worksheet Label
Question details
The user needs to rename the Employee Costs heading to Income and update a calculation so expenses are deducted from the income value.
- Product
- WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- A spreadsheet contains an Employee Costs heading and a calculation that must be changed to show income after expenses.
- Observed behavior
- The exact formula and cell references cannot be determined without the workbook structure, so the required income and expense cells or ranges must be identified first.
Open the workbook in WPS Spreadsheet and identify the cell containing Employee Costs, the cell containing the income total, the expense total or range, and the cell that displays the result. Make a copy of the workbook if you need to preserve the original formula.
Rename the heading and subtract expenses from income
Use this method when the heading is stored in a worksheet cell and you know the cells or ranges containing income and expenses.
Replace the text in the heading cell, then edit the result cell so it subtracts the expense total from the income total. The exact references depend on the workbook layout.
For example, if income is in B2 and expenses are listed in C2:C10, the result formula can be =B2-SUM(C2:C10).
In WPS Spreadsheet, select the cell containing Employee Costs, type Income, and press Enter. You can also double-click the cell or edit its contents in the formula bar.
Select the cell that should display income after expenses and check the formula bar to see its current formula and referenced cells.
Click the formula bar or press F2, enter a formula such as =B2-SUM(C2:C10), replace B2 and C2:C10 with the actual income cell and expense range, and press Enter.
Check that the result equals the income value minus the total expenses. Change a test expense value temporarily to confirm that the result updates.
Rename the worksheet tab instead of a heading cell
Use this option only when Employee Costs is the name shown on the worksheet tab at the bottom of the workbook.
Edit headings and update expense formulas in WPS Spreadsheet
WPS Spreadsheet lets you rename a heading or worksheet tab, edit formulas directly in the formula bar, and calculate income after expenses using ordinary cell references and SUM ranges.
- 1. Open the workbook: Launch WPS Office, choose Spreadsheet, and open the workbook containing the heading and calculation.
- 2. Edit the label: Select the cell containing Employee Costs and replace it with Income, or right-click the worksheet tab and choose Rename if the tab itself needs changing.
- 3. Update the formula: Select the result cell, click the formula bar, and enter an expression such as =B2-SUM(C2:C10), changing the references to match the workbook.
- 4. Check and save: Confirm that the displayed result is income minus expenses, then use File > Save or press Ctrl+S to save the updated XLS or XLSX workbook.
Frequently Asked Questions
How do I change Employee Costs to Income in WPS Spreadsheet?
Select the cell containing Employee Costs, type Income, and press Enter. If Employee Costs appears on the worksheet tab, right-click the tab, select Rename, enter Income, and press Enter.
What formula subtracts expenses from income?
Use a formula such as =B2-SUM(C2:C10), where B2 contains the income value and C2:C10 contains the expenses. Replace these references with the actual cells or range in your workbook.
Why can’t the exact formula be provided without the workbook?
A formula depends on the workbook’s cell locations, layout, and whether expenses are stored in one total cell or a range. The relevant cell addresses are needed to create an exact formula.
How can I check whether the revised calculation is correct?
Select the result cell and review the formula bar. Compare the result with the income total minus the expense total, or temporarily change an expense value and confirm that the result updates accordingly.
