Feature Summary

The Show Page Breaks feature is used to display the positions of automatic and manual page breaks in Normal view, making it easier for users to understand the pagination of the document.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Enabling Show Page Breaks

Feature Entry ①

"File" tab → "Spreadsheet Preferences" → "View" → Check/Uncheck "Page Breaks"

  1. Click the File tab
  2. Select Spreadsheet Preferences
  3. Click View
  4. Check Page Breaks
  5. Checking it again will hide the page breaks

image

image

Feature Entry ②

"Page" tab → "Show Page Breaks"

  1. Click the Page tab
  2. Click Show Page Breaks to display page breaks
  3. Checking it again will hide the page breaks

image

Viewing Page Breaks

Feature Entry

Normal View

  1. After enabling Show Page Breaks
  2. Dashed lines indicate automatic page breaks
  3. Solid lines indicate manually inserted page breaks
  4. You can intuitively see the pagination positions

image

FAQ

Q1: What should I do if I have enabled Show Page Breaks but cannot see them?

  • Solution: Make sure you are in Normal view mode. Page Break Preview mode always shows page break lines.

Q2: What is the difference between automatic and manual page breaks?

  • Solution: Automatic page breaks are calculated automatically by the system based on page size (dashed lines), while manual page breaks are inserted by the user (solid lines).

Notes

  • The Show Page Breaks setting is a global setting and affects all worksheets
  • Page break positions will automatically adjust as page settings change
  • It is recommended to enable this feature when editing large spreadsheets