Feature Summary

The WPS Sheets interface consists of the title bar, menu bar (ribbon), editing area, status bar, and task pane. These areas work together to provide users with a complete spreadsheet editing environment.

1. Title Bar

The title bar is located at the very top of the WPS Sheets window. It displays the current document name and software name, and provides window control buttons and quick access functions.

Viewing the Document Name

Function Entry
Title bar at the top of the window

  1. Open a WPS Sheets document
  2. The current document name is displayed in the center of the title bar
  3. When the document has not been saved, a default name such as "Book1" is displayed

image

Using Window Control Buttons

Function Entry
Left side of the title bar

  1. Click the Minimize button to minimize the window to the taskbar
  2. Click the Maximize/Restore button to toggle full-screen display of the window
  3. Click the Close button to close the current document window

Using the Quick Access Toolbar

Function Entry
Left side below the title bar

  1. The Quick Access Toolbar is displayed on the left side of the title bar
  2. By default, it includes common buttons such as Save, Undo, and Redo
  3. Click the drop-down arrow to customize and add common commands, as well as change the position of the Quick Access Toolbar

2. Menu Bar (Ribbon)

The menu bar is located below the title bar and contains main function tabs such as File, Home, Insert, Page Layout, Formulas, Data, Review, and View. It is the primary entry point for accessing all features of WPS Sheets.

Using the File Menu

Function Entry
"File" tab

  1. Click the File tab
  2. You can perform document operations such as New, Open, Save, and Save As
  3. It includes functions such as Print, Share, and Export

image

3. Ribbon

The ribbon is the main operation area below the menu bar. It organizes various functions by tabs, providing an intuitive graphical operation interface that allows users to quickly find and use the required functions.

Expanding/Collapsing the Ribbon

Function Entry
Quick Access Toolbar

  1. Click "Show Ribbon" in the drop-down arrow of the Quick Access Toolbar to collapse the ribbon
  2. Double-click again to expand the ribbon

image

Using Function Groups

Function Entry
Function groups under each tab

  1. The ribbon organizes related functions into function groups
  2. For example, the "Home" tab contains groups such as Clipboard, Font, and Alignment
  3. Click the arrow in the lower-right corner of a group to open the detailed settings dialog box

image

Using Contextual Tools

Function Entry
Appears after selecting a specific object

  1. When you select an object such as a picture, chart, or table
  2. The ribbon automatically displays the corresponding contextual tool tab
  3. For example, selecting a picture will display the "Picture Tools" tab

image

4. Editing Area

The editing area is the core workspace of WPS Sheets. It is used to display and edit cell content, supporting operations such as data entry, formula calculation, and formatting.

Selecting Cells

Function Entry
Cells in the editing area

  1. Click a cell to select a single cell
  2. Hold and drag the mouse to select a continuous range

Entering Data

Function Entry
Cells in the editing area

  1. Double-click a cell or select it and start typing directly
  2. Press Enter to confirm the input and move to the cell below
  3. Press Tab to confirm the input and move to the cell on the right

Editing Cell Content

Function Entry
Cells in the editing area or the formula bar

  1. Double-click a cell to enter edit mode
  2. Or select the cell and modify the content in the formula bar
  3. Press Esc to cancel editing

Using Scroll Bars

Function Entry
Right side and bottom of the editing area

  1. Drag the vertical scroll bar to browse up and down
  2. Drag the horizontal scroll bar to browse left and right
  3. Use the mouse wheel to scroll quickly

5. Status Bar

The status bar is located at the bottom of the WPS Sheets window. It displays the current operation status, selection statistics (such as sum, average, and count), as well as view switching and zoom controls.

View Selection Statistics

Feature Entry
Middle of the status bar

  1. Select a range of cells containing numeric values
  2. The status bar automatically displays statistical information such as Sum, Average, and Count
  3. Right-click the status bar to customize the displayed statistical items

image

Switch View Mode

Feature Entry
Right side of the status bar

  1. Click the Normal View button to switch to the normal editing view
  2. Click the Page Layout button to view the start/end of the document and check headers/footers
  3. Click the Page Break Preview button to view the print page break effect
  4. Click the Full Screen button to enter full-screen display mode

Adjust Zoom Level

Feature Entry
Far right of the status bar

  1. Drag the zoom slider to adjust the display scale
  2. Click the + / - buttons to fine-tune the zoom
  3. Click the zoom percentage to enter an exact value directly

6. Task Pane

The task pane is an auxiliary function panel in WPS Sheets, providing quick-access tools for styles, clipboard, properties, etc. It can float next to the editing area for convenient use.

Open the Task Pane

Feature Entry
"View" tab → "Task Pane"

  1. Click the View tab
  2. Click the Task Pane button to expand or close the task pane

image

FAQ

Q1: What should I do if the ribbon is missing?

  • Solution: Click the drop-down arrow on the Quick Access Toolbar and click "Show Ribbon" to collapse the ribbon.

Q2: What should I do if the editing area is not fully displayed?

  • Solution: Adjust the window size, or use the zoom function (View → Zoom) to adjust the display scale.

Q3: What should I do if the status bar does not show statistical information?

  • Solution: Click "Set Statistical Items" on the bottom status bar and check the statistical items you want to display (Sum, Average, Count, and so on.).

Notes

  • Menu items may vary slightly between different versions of WPS Sheets. Some advanced features require a membership subscription.
  • The editing area supports switching between multiple sheets (via the sheet tabs at the bottom). You can freeze panes to lock row and column headers.
  • Status bar statistics are only valid for numeric data. Different selection ranges will display different statistical results.
  • The task pane can be shown or hidden as needed. The pane's position and state will be remembered.