Feature Summary
Row and column headers are a navigation aid in WPS Sheets collaboration mode, controlling whether the row numbers (1, 2, 3...) on the left and column letters (A, B, C...) at the top of the sheet are displayed, making it easier to quickly locate cells.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restrictions | No membership restrictions |
| Version Restrictions | No version restrictions |
Steps
Show/Hide Row and Column Headers
Feature Entry Point
"View" tab → "Row and Column Headers"
- Click the "View" tab at the top
- Find the "Row and Column Headers" toggle button (or checkbox) in the toolbar
- Click to enable (when enabled, row numbers appear on the left and column letters appear at the top)
- Click again to disable, hiding row numbers and column letters
- Changes only affect the display of the current worksheet and do not affect other worksheets
Feature Entry Point ②
"Display Settings" in the status bar at the bottom of the screen
- Click the "Display Settings" button in the status bar at the bottom right corner of the screen
- Find the "Row and Column Headers" toggle button
FAQ
Q1: What are the practical scenarios for row and column headers?
- Solution: Row and column headers are very important for data referencing, formula writing, and data navigation. Hiding row and column headers provides a larger content display area, but it is recommended to keep them visible during data analysis and formula writing.
Q2: Will hiding row and column headers affect navigation?
- Solution: No. Row and column headers are only a display/hide control. After hiding, scrolling, data referencing, and other functions still work normally; only the auxiliary row number and column letter text is not displayed.
Q3: Will row and column header settings be printed?
- Solution: No. Row and column headers are an on-screen display aid and are not included by default when printing. However, if the "Row and Column Headers" print option is enabled in print settings, they can be included in the printout.
Notes
- Changes to row and column headers only affect the display of the current worksheet
- Hiding row and column headers maximizes the content display area
- It is recommended to keep them visible for easier data navigation and formula referencing