How To Print Gridlines And Headings In Excel (2026)

Excel does not print gridlines or the row numbers and column letters unless you ask it to.

Both are one check box on the Page Layout tab.

This guide shows where to find them, how to check the result in print preview, and what to try when gridlines still will not print.

Quick answer: print gridlines and headings

To printGo toThen
GridlinesPage Layout > Sheet Options > GridlinesSelect the Print check box
Row and column headingsPage Layout > Sheet Options > HeadingsSelect the Print check box
Either one, from a dialogSelect the launcher icon in the Sheet Options groupUnder Print, tick Gridlines or Row and column headings

After ticking the box, press Ctrl + P and select Print.

  1. Select the worksheet you want to print.
  2. Go to Page Layout and find the Sheet Options group.
  3. Under Gridlines, select the Print check box.
  4. Go to File > Print, or press Ctrl + P.
  5. Select Print.

Gridlines are off by default on a printed worksheet.

Gridlines are a screen display setting, so showing them on screen does not make them print.

  1. Select the worksheet.
  2. Open the Page Layout tab.
  3. In the Sheet Options group, find Headings and tick the Print box.
  4. Press Ctrl + P to open the Print dialog, then select OK or Print.

You can also select the small launcher icon in the Sheet Options group and tick Row and column headings under Print.

You cannot change the letters or numbers in the headings, so type your own labels into cells if you need different ones.

Check the result in print preview

Press Ctrl + F2 in some versions, or open File > Print, to see how the page will look before you print.

On Excel for Mac, Print Preview is under Sheet Options on the Page Layout tab.

Gridlines print only around cells that contain data.

To print gridlines around empty cells, set a print area that includes them or apply cell borders instead.

Print several sheets at once

If you select more than one worksheet, the title bar shows Group.

Any setting you change then applies to every sheet in the group.

To cancel the grouping, click any unselected sheet, or right-click a selected sheet tab and choose Ungroup Sheets.

Use the Page Setup Sheet tab

Go to File > Print > Page Setup, then open the Sheet tab to find every print option in one place.

OptionWhat it does
GridlinesIncludes worksheet gridlines in the printout, off by default
Row and column headingsIncludes row numbers and column letters
Black and whitePrints in black and white on a color printer, off by default
Draft qualityPrints faster at lower quality on printers that have a draft mode
Comments and notesNone, At end of sheet or As displayed on sheet
Cell errors asDisplayed, blank, a double hyphen (–) or #N/A

The same tab holds Print area and the Rows to repeat at top and Columns to repeat at left settings.

Fix gridlines that will not print

CauseWhat to do
Sheet Options boxes are dimmedA chart, image or other object may be selected, so click a cell to cancel that selection
Draft quality is onFile > Print > Page Setup > Sheet tab, then clear Draft quality (shortcut Alt + P, S, P)
Cells have a fill colorFills hide gridlines, so use Home > Font > Fill Color arrow > No Fill, because even a white fill hides them
Printer driver problemInstall the latest driver from the printer manufacturer
Nothing else worksApply borders to the cells you want to print

Column headings show numbers, not letters

If columns are labelled with numbers, the workbook uses the R1C1 reference style.

Go to File > Options > Formulas and, under Working with formulas, clear the R1C1 reference style check box.

Show, hide or recolor gridlines on screen

To hide gridlines on screen, select the worksheet and clear Gridlines in the Show group on the View tab.

Select the same check box to show them again.

To change the color for one worksheet, go to File > Options > Advanced > Display options for this worksheet > Gridline color.

Gridlines apply to the whole worksheet, so use borders when you want lines in only some places.

Change the gridline color

  1. Select the worksheets you want to change.
  2. Go to File > Options.
  3. In the Advanced category, under Display options for this worksheet, make sure Show gridlines is checked.
  4. Open the Gridline color list and choose a color.

The change applies only to the worksheets you selected.

Gridlines use the Automatic color by default, so choose Automatic in the list to restore it.

A new gridline color does not make gridlines print, because printing is still controlled by the Print box in Sheet Options.

Print gridlines and headings on Excel for Mac

Microsoft’s Mac steps for gridlines are short: select the sheet, open the Page Layout tab, select the Print check box under Gridlines, then choose File > Print.

Microsoft’s Mac page also says the Page Layout tab offers page orientation, paper size and whether to print gridlines and headings.

TaskExcel for Mac
Print gridlinesPage Layout > Gridlines > Print, then File > Print
Preview the resultPrint Preview under Sheet Options on the Page Layout tab
Choose what to printFile > Print > Show Details, then the Print drop-down: Selection, Active Sheets or Entire Workbook
Select several sheetsShift-click adjacent tabs or Command-click nonadjacent tabs

When several sheets are selected, Group appears in the title bar, and Ctrl-click on a selected tab lets you choose Ungroup Sheets.

  1. Select the worksheet, then select the range you want.
  2. Go to File > Print.
  3. Under Settings, open the arrow next to Print Active Sheets and choose the option you need.
  4. Select Print.

If a sheet has a defined print area, Excel prints only that area unless you select Ignore print area under Settings.

To print an Excel table, click a cell inside it and choose Print Selected Table from the same arrow.

For related print settings, see how to set and clear a print area, how to repeat header rows on every printed page and how to fit a sheet on one page.

If Excel will not print at all, read why Word or Excel will not print on Windows 11.

Official sources: Print gridlines in a worksheet, Print row and column headings and Show or hide gridlines on a worksheet.

Leave a Reply

Your email address will not be published. Required fields are marked *