How to Use WPS Grid Lines on Windows

Use Grid Lines with 4 how-to topics: quickly show or hide grid lines, change display status from Options, modify grid line color, and show grid lines when printing.

How-to Index

How-to Guide

1. Quickly Show or Hide Grid Lines from the View Tab

Feature entry: View tab → Show Grid Lines checkbox

1. Open WPS Spreadsheet and go to the worksheet you want to edit.
2. Click the View tab.
3. In the display area, find Show Grid Lines.
4. Select the checkbox to show grid lines, or clear it to hide them.

Success Criteria

• Interface result: the gray cell divider lines appear or disappear immediately.
• What you can do next: continue entering, editing, or reviewing worksheet content.

Tips While Using

• Common mistake: do not confuse worksheet borders with grid line display.

2. Show or Hide Grid Lines from the File Menu

Feature entry: File → Options → View → Gridlines

1. Click the File menu in the upper-left corner.
2. Click Options.
3. Switch to the View panel.
4. In the display section, select or clear Gridlines.
5. Confirm the setting and close the window.

Success Criteria

• Interface result: the worksheet updates to the selected grid line display state.
• What you can do next: return to the worksheet and keep editing.

Tips While Using

• Common mistake: if you only need a quick temporary switch, the View tab is usually faster.

3. Change Grid Line Color in Options

Feature entry: File → Options → View → Window Options → Grid Line Color

1. Click the File menu in the upper-left corner.
2. Click Options.
3. Switch to the View panel in the Options window.
4. Find Grid Line Color in the window options area.
5. Open the drop-down list and choose the color you want.
6. Click OK to save the setting.

Success Criteria

• Interface result: the worksheet grid lines update to the selected color.
• What you can do next: continue viewing or editing the worksheet.

Tips While Using

• Common mistake: existing cell borders may visually cover grid lines in some areas.

4. Show Grid Lines When Printing

Feature entry: Page Layout → Page Setup → Sheet → Gridlines

1. Open the worksheet you want to print.
2. Click the Page Layout tab.
3. Click the dialog launcher in the lower-right corner of Page Setup.
4. In the Page Setup dialog box, switch to the Sheet tab.
5. Select Gridlines, then click OK.
6. Open print preview or print the worksheet to check the output.

Success Criteria

• Interface result: grid lines are visible in print preview.
• What you can do next: print the worksheet or continue adjusting page settings.

Tips While Using

• Common mistake: hiding grid lines on screen does not automatically hide them in printed output.
• Environment note: use print preview or an available printer to confirm the final result.