Printing Problems

How to Print Light Gray Gridlines in Excel for Mac

Tauseeq MagsiTauseeq Magsi Oct 8, 2026 872 views

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.

How to Print Light Gray Gridlines in Excel for Mac
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.
Before you start

Use Print Preview (Command+P) before making changes to see if your current lines are actual gridlines or manually applied cell borders.

Solution 1Recommended

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.

1
Set the gridline color

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.

2
Enable gridlines for printing

Navigate to the 'Page Layout' tab on the Excel ribbon. Locate the 'Gridlines' section and check the box labeled 'Print'.

3
Verify in Print Preview

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.

Enable Printed Gridlines and Adjust View Color
Gridlines vs. Borders: Gridline settings affect the entire worksheet. If you only want lines around specific cells, you should use cell borders instead.
Easier Printing with WPS Spreadsheet

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. 1. Open your workbook in WPS Spreadsheet: Launch WPS Office on your Mac and open your existing spreadsheet document.
  2. 2. Navigate to the Page Layout tab: Click on 'Page Layout' in the main ribbon at the top of the application.
  3. 3. Enable Print Gridlines: Find the 'Gridlines' option group and check the box that says 'Print'.
  4. 4. Preview and Print: Press Command+P to open the print preview window, verify your gridlines, and click Print.
Fully compatible with Microsoft Excel (.xlsx and .xls) formatsIntuitive Page Layout tab for instant print configurationLightweight application optimized for smooth Mac performanceFree and robust alternative for all your spreadsheet tasks
QA img-9

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.