When printing an Excel sheet for a report or presentation, the gridlines, row numbers, and column letters can look cluttered. These elements are helpful for editing but are often unnecessary on a final printed page. This guide explains how to remove the row and column headings from your printouts. You will learn to hide these elements using Excel’s Page Layout view and print settings.
Key Takeaways: Hiding Headings for Printing
- Page Layout tab > Sheet Options > Headings: Uncheck the Print box to remove row numbers and column letters from your final printout.
- Page Setup dialog box: Access advanced print settings to control headings, gridlines, and print area on a per-sheet basis.
- View > Page Layout: Preview exactly how your sheet will look when printed, with or without headings visible on screen.
Understanding Excel’s Print Headings and Gridlines
Excel displays row numbers and column letters by default to help you navigate and reference cells. These are called “headings.” Similarly, the light gray lines between cells are “gridlines.” Both are screen elements designed for worksheet creation. For a polished, report-ready document, you typically want to hide them before printing.
It is important to know the difference between hiding these elements on screen and hiding them for print. You can choose to keep them visible while you work but exclude them from the printed page. The settings are controlled separately in the Page Layout tab. This gives you full control over the final output without affecting your editing workspace.
Steps to Hide Headings and Gridlines for Printing
The most direct method uses the ribbon commands on the Page Layout tab. This affects the active worksheet.
- Select your worksheet tab
Click the tab at the bottom of the Excel window for the sheet you want to print. - Go to the Page Layout tab
Find this tab on the Excel ribbon between Formulas and Data. - Locate the Sheet Options group
In this group, you will see two sections: Gridlines and Headings. Each has a View checkbox and a Print checkbox. - Uncheck the Print box under Headings
This action tells Excel not to print the row numbers (1, 2, 3) and column letters (A, B, C). The headings will still show on your screen. - Uncheck the Print box under Gridlines
For a completely clean printout, also uncheck this box. This removes the cell borders from the printed page. - Preview your printout
Press Ctrl+P to open the print preview. Verify that the headings and gridlines are absent from the preview pane.
Using the Page Setup Dialog for More Control
For more detailed print settings, use the Page Setup dialog box.
- Open the Page Setup dialog
On the Page Layout tab, click the small dialog launcher arrow in the bottom-right corner of the Page Setup group. - Go to the Sheet tab
In the dialog box, click the Sheet tab at the top. - Find the Print section
Look for checkboxes labeled Gridlines and Row and column headings. - Adjust the checkboxes
Uncheck Row and column headings to hide them for printing. Uncheck Gridlines if needed. Click OK to apply.
Common Mistakes and Things to Avoid
Hiding Headings on Screen Instead of for Print
A common error is unchecking the View box instead of the Print box in the Sheet Options group. If your headings disappear from the screen but still print, you changed the View setting. To fix this, re-check the View box under Headings on the Page Layout tab, and ensure the Print box is unchecked.
Settings Not Applying to All Sheets
Print settings for headings and gridlines are worksheet-specific. Changing them on Sheet1 does not affect Sheet2. If you need the same setting for multiple sheets, select all relevant sheet tabs first. Hold Ctrl and click each tab, then change the Print settings in the Page Layout tab. The change will apply to all selected sheets.
Print Area Includes Hidden Rows or Columns
Hiding row numbers does not hide the data in rows or columns you have manually hidden. If you hide row 5, the numbering will skip from 4 to 6 on screen, but the print setting only removes the numbers themselves. To exclude data from a printout, set a specific print area via Page Layout > Print Area > Set Print Area.
On-Screen View vs Print Settings Comparison
| Item | Page Layout View Settings | Print Dialog Settings |
|---|---|---|
| Primary Control Location | Page Layout tab, Sheet Options group | Page Setup dialog, Sheet tab |
| Controls Headings Visibility | Separate checkboxes for View and Print | Single Row and column headings checkbox for print only |
| Immediate Visual Feedback | Yes, screen updates in Page Layout view | No, requires a print preview to see changes |
| Ability to Set Print Area | No, requires separate command | Yes, includes a field to define print range |
| Best For | Quick toggling and visual design | Comprehensive print job configuration |
You can now produce clean, professional printouts from Excel by hiding the worksheet headings. Use the Print checkbox in the Sheet Options group for the fastest method. For more advanced layout control, explore the Header/Footer tab in the Page Setup dialog to add titles or page numbers. Remember that applying borders to cells is often better than relying on printed gridlines for defining data areas.