How to Use WPS Row and Column Headings on macOS

Last updated:July 20, 2026

Use WPS Row and Column Headings with 2 how-to topics, both available without membership; choose a topic from the index and follow the matching entry path and steps.

How-to Index

No.TopicMembership Requirement
11. Turn Row and Column Headings On or Off from the View TabFree
22. Switch Row and Column Headings from Display Settings on the Status BarFree

How-to Guide

1. Turn Row and Column Headings On or Off from the View Tab

Entry path: Top View tab → Row and Column Headings

  1. Open WPS Spreadsheet and go to the worksheet you want to view.
  2. Click the View tab at the top.
  3. Find the Row and Column Headings toggle or checkbox on the toolbar.
  4. Click it once to turn the headings on. Row numbers appear on the left, and column letters appear at the top.
  5. Click it again to turn the headings off and hide those markers.
  6. This change affects only the current worksheet display and does not change other worksheets.

Success Criteria

  • Interface result: Row numbers and column letters are visible when turned on and hidden when turned off.
  • What you can do next: Continue entering data, selecting cells, editing formulas, or switching to another worksheet.
  • No side effects: Cell content and worksheet structure stay unchanged.

Tips While Using

  • Common mistake: If you are not in a spreadsheet worksheet view, the related entry may not appear.
  • Environment note: This is a display setting and does not change file content.

2. Switch Row and Column Headings from Display Settings on the Status Bar

Entry path: Bottom-right status bar → Display Settings → Row and Column Headings

  1. Open WPS Spreadsheet and go to the target worksheet.
  2. Find the Display Settings button on the bottom-right side of the status bar.
  3. Click Display Settings to view available display options.
  4. Find the Row and Column Headings switch.
  5. Click the switch to show or hide the headings based on your current need.

Success Criteria

  • Interface result: The worksheet updates the row number and column letter display immediately.
  • What you can do next: Continue presenting, taking screenshots, or reviewing worksheet content.
  • No side effects: No worksheet content is changed beyond the display state described here.

Tips While Using

  • Common mistake: If the window is small, the status bar entry may be less noticeable at first.
  • Environment note: This entry is useful for quick display changes, especially before presenting or capturing screenshots.