How to Print Light Gray Gridlines in Excel for Mac
Question details
The user needs to print a worksheet with light gray gridlines but needs to configure both the visual gridline color and the print settings independently.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Preparing an Excel worksheet for printing and attempting to make the printed gridlines appear light gray rather than solid black.
- Observed behavior
- Gridlines do not appear on printed sheets by default, or they print as solid black lines because cell borders were applied instead of configuring the actual gridline settings.
Use Print Preview (Command+P) before making changes to see if your current lines are actual gridlines or manually applied cell borders.
Enable Printed Gridlines and Adjust View Color
Activate the print gridlines feature and configure the on-screen gridline color to light gray in Excel preferences.
By default, Excel does not print the gridlines you see on your screen. You must explicitly tell Excel to print them, and you can adjust their color via the application preferences.
Click on 'Excel' in the top Mac menu bar, select 'Preferences', and click on 'View'. Under the Window options, select the color dropdown next to 'Gridlines' and choose your preferred light gray.
Navigate to the 'Page Layout' tab on the Excel ribbon. Locate the 'Gridlines' section and check the box labeled 'Print'.
Press Command+P or go to File > Print to open the Print dialog. Review the preview pane to ensure the light gray gridlines are visible before printing.

Remove or Modify Solid Black Cell Borders
If your lines are still printing solid black despite changing the gridline color, you likely have cell borders applied.
Easily Print Gridlines in WPS Spreadsheet for Mac
WPS Office provides an incredibly intuitive interface for managing spreadsheet layouts and print settings on Mac. You can enable printed gridlines and customize your page layout in just a few clicks.
- 1. Open your workbook in WPS Spreadsheet: Launch WPS Office on your Mac and open your existing spreadsheet document.
- 2. Navigate to the Page Layout tab: Click on 'Page Layout' in the main ribbon at the top of the application.
- 3. Enable Print Gridlines: Find the 'Gridlines' option group and check the box that says 'Print'.
- 4. Preview and Print: Press Command+P to open the print preview window, verify your gridlines, and click Print.

Frequently Asked Questions
Why do my Excel gridlines print black even after changing the gridline color?
You likely have cell borders applied to your data. Gridline color settings do not override cell borders. Select the cells, press Command+1, go to the Border tab, and either remove the borders or change their color to gray.
Can I print gridlines for only a specific section of my Excel Mac worksheet?
Gridline settings apply to the entire active worksheet. If you only want lines in a specific section, disable 'Print gridlines' in the Page Layout tab and instead manually apply light gray cell borders to your desired range using Command+1.
How do I change the default gridline color for all new Excel workbooks on Mac?
Excel saves gridline color settings per worksheet. To have light gray gridlines by default, you must create a blank workbook, change the gridline color in Excel > Preferences > View, and save it as an Excel Template (.xltx) in your startup folder.




