'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Remove Column and Row Headings When Printing in Excel
Question details
The user wants to prevent column letters and row numbers from appearing on the physical pages when printing a spreadsheet.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing a completed spreadsheet for printing or PDF export and wanting a clean layout without the application's default grid headers.
- Observed behavior
- Column letters (A, B, C) and row numbers (1, 2, 3) are currently being included in the printed output alongside the actual spreadsheet data.
Ensure your printer is correctly connected and open the Print Preview (Ctrl + P) to verify whether the column and row headings are currently visible on the document layout.
Disable Headings from the Page Layout Tab
Use the Sheet Options in the Page Layout ribbon to quickly turn off printed headings before sending your document to the printer.
Excel allows you to control exactly what elements of the worksheet interface are included on your printed pages. By default, row and column headings might be toggled on for specific templates or previously modified files.
Open your Excel spreadsheet and navigate to the 'Page Layout' tab located on the top ribbon.
Find the 'Sheet Options' group within the Page Layout ribbon, which contains settings for Gridlines and Headings.
Under the 'Headings' section, clear the checkbox next to 'Print'. The column letters and row numbers will no longer be queued for printing.
Press Ctrl + P (or go to File > Print) to open the Print Preview. Confirm that the column and row headings have been successfully removed from the previewed page.
Print Spreadsheets Cleanly with WPS Office
WPS Spreadsheet offers a highly compatible and intuitive way to manage your print settings, allowing you to remove row and column headings with just a few clicks.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet document you wish to print.
- 2. Navigate to Page Layout: Click on the 'Page Layout' tab found in the main upper toolbar.
- 3. Turn off Print Headings: Locate the 'Print Headings' option in the ribbon and uncheck it to remove the A-Z and 1-100 indicators from your final printed page.
Frequently Asked Questions
Why are my Excel row and column headings printing by default?
In most standard configurations, Excel defaults to not printing headings. However, if a specific page setup, macro, or custom template was used previously, the 'Print Headings' option might have been manually enabled in the Page Setup dialog.
Can I remove gridlines when printing as well?
Yes. Right next to the Headings option in the Page Layout tab, you will find a 'Gridlines' section. Uncheck the 'Print' box there to ensure the cell border lines do not appear on your printed paper.
How do I repeat specific row or column headers on every printed page?
To repeat your actual data labels (like a custom title row) on every printed page, go to Page Layout > Print Titles. In the Page Setup dialog box, select the specific rows or columns you want to repeat under 'Rows to repeat at top' or 'Columns to repeat at left'.
Does unchecking print headings hide them on my computer screen too?
No. Unchecking the 'Print' box under Headings only removes them from the physical paper or exported PDF. To hide them on your digital workspace screen, you must uncheck the 'View' box located in the same Headings section.
