How to Fix Excel Gridlines Missing in One Column or Not Printing in WPS Office
Question details
A user needs to restore missing gridlines in one column of a WPS Office spreadsheet and ensure gridlines appear when printing.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user enabled gridlines, but a specific column is blank in Print Preview.
- Observed behavior
- A fill color applied to cells hides worksheet gridlines, so the affected column does not display or print gridlines even when gridlines are enabled.
Open the workbook in WPS Office Spreadsheets and check that View > Gridlines is enabled; if only one column is affected, a fill color applied to those cells is the likely cause.
Remove Fill Color from the Affected Column to Restore Gridlines
Use this when a fill color applied to a column hides gridlines on screen and in Print Preview.
Excel and WPS Spreadsheets do not display or print worksheet gridlines through cells that have a fill color.
Click the column letter at the top of the affected column, such as March, to select the entire column.
Go to the Home tab and click the Fill Color drop-down arrow in the Font group.
Select No Fill from the color palette to remove the fill color from the selected cells.
Open File > Print or use Print Preview to confirm gridlines now appear in that column.
Apply Borders for Reliable Printed Gridlines
Use this if you need visible lines in printed reports even when cell fills or formatting change.
Restore Missing Gridlines in WPS Office Spreadsheets
Open the affected WPS Office spreadsheet, remove the fill color from the column, and apply borders if you need reliable printed lines.
- 1. Open your workbook: Launch WPS Office Spreadsheets and open the workbook with the missing gridlines.
- 2. Select the affected column: Click the column header for the affected column to select all its cells.
- 3. Open Fill Color: On the Home tab, click the Fill Color arrow in the Font group and choose No Fill.
- 4. Apply borders if needed: Click the Borders drop-down on the Home tab and choose All Borders for lines that must print.
- 5. Check print preview: Click File > Print to confirm gridlines or borders appear in the printed version.
Frequently Asked Questions
Why do gridlines disappear in only one column in Excel or WPS Spreadsheets?
Gridlines are hidden when a cell fill color is applied because worksheet gridlines cannot show through a fill. Select the column, go to Home > Fill Color, and choose No Fill to restore them.
How do I remove fill color from a column in WPS Office?
Click the column letter to select it, open the Home tab, select the Fill Color drop-down, and choose No Fill. Then check the column in Print Preview.
How can I print gridlines in WPS Spreadsheets?
First confirm View > Gridlines is enabled and remove fill colors from the affected cells. For consistent printed lines, apply borders via Home > Borders > All Borders, as borders print regardless of gridline settings.
Why are gridlines visible on screen but missing in Print Preview?
Worksheet gridlines may not be set to print, or fill colors may be hiding them. In WPS Spreadsheets, check the Page Layout settings for gridlines printing and remove any fill color that blocks them.
