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 print | Go to | Then |
|---|---|---|
| Gridlines | Page Layout > Sheet Options > Gridlines | Select the Print check box |
| Row and column headings | Page Layout > Sheet Options > Headings | Select the Print check box |
| Either one, from a dialog | Select the launcher icon in the Sheet Options group | Under Print, tick Gridlines or Row and column headings |
After ticking the box, press Ctrl + P and select Print.
Print gridlines
- Select the worksheet you want to print.
- Go to Page Layout and find the Sheet Options group.
- Under Gridlines, select the Print check box.
- Go to File > Print, or press Ctrl + P.
- 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.
Print row and column headings
- Select the worksheet.
- Open the Page Layout tab.
- In the Sheet Options group, find Headings and tick the Print box.
- 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.
| Option | What it does |
|---|---|
| Gridlines | Includes worksheet gridlines in the printout, off by default |
| Row and column headings | Includes row numbers and column letters |
| Black and white | Prints in black and white on a color printer, off by default |
| Draft quality | Prints faster at lower quality on printers that have a draft mode |
| Comments and notes | None, At end of sheet or As displayed on sheet |
| Cell errors as | Displayed, 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
| Cause | What to do |
|---|---|
| Sheet Options boxes are dimmed | A chart, image or other object may be selected, so click a cell to cancel that selection |
| Draft quality is on | File > Print > Page Setup > Sheet tab, then clear Draft quality (shortcut Alt + P, S, P) |
| Cells have a fill color | Fills hide gridlines, so use Home > Font > Fill Color arrow > No Fill, because even a white fill hides them |
| Printer driver problem | Install the latest driver from the printer manufacturer |
| Nothing else works | Apply 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
- Select the worksheets you want to change.
- Go to File > Options.
- In the Advanced category, under Display options for this worksheet, make sure Show gridlines is checked.
- 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.
| Task | Excel for Mac |
|---|---|
| Print gridlines | Page Layout > Gridlines > Print, then File > Print |
| Preview the result | Print Preview under Sheet Options on the Page Layout tab |
| Choose what to print | File > Print > Show Details, then the Print drop-down: Selection, Active Sheets or Entire Workbook |
| Select several sheets | Shift-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.
Print only part of a sheet
- Select the worksheet, then select the range you want.
- Go to File > Print.
- Under Settings, open the arrow next to Print Active Sheets and choose the option you need.
- 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.
Related Excel guides
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.