This section includes 2 how-to topics for Row and Column Headings, covering the View tab and Display Settings on the status bar; 2 items are free and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Show or hide Row and Column Headings from the View tab | Free |
| 2 | 2. Switch Row and Column Headings from Display Settings | Free |
How-to Guide
1. Show or hide Row and Column Headings from the View tab
Entry point: View tab at the top of the window → Row and Column Headings
- Open WPS Spreadsheet and go to the worksheet you want to check.
- Click the View tab at the top of the window.
- Find the Row and Column Headings toggle or checkbox in the toolbar.
- Click it once to show the headings, so row numbers appear on the left and column letters appear at the top.
- Click it again to hide the headings.
- Confirm that the change applies to the current worksheet display.
Success Criteria
- Interface result: Row numbers and column letters are shown or hidden as expected.
- What you can do next: You can continue editing, entering formulas, selecting cells, or saving the file.
- No side effects: Other worksheets and cell data are not changed.
Tips While Using
- Common mistake: After changing one worksheet, users may expect the whole workbook to update the same way.
- Environment note: If the window is narrow, some toolbar items may appear in a collapsed area.
2. Switch Row and Column Headings from Display Settings
Entry point: Bottom-right status bar area → Display Settings → Row and Column Headings
- Open WPS Spreadsheet and go to the target worksheet.
- Find Display Settings in the bottom-right area of the window.
- Click Display Settings to open the available display options.
- Find the Row and Column Headings switch.
- Click the switch and check the worksheet edges immediately.
Success Criteria
- Interface result: Row numbers and column letters update immediately based on the switch state.
- What you can do next: You can continue browsing, editing, and locating cells.
- No side effects: Other worksheet content is not changed.
Tips While Using
- Common mistake: Display Settings can be confused with print settings.
- Environment note: The exact position of the status bar entry can vary with the current window layout.