If your Excel sheet spans multiple pages, then you must display either the default row numbers and column letters or the row and column headers for clear identification. This article covers these two distinct situations on how to print an Excel sheet with rows and columns.
Steps to Print Excel’s Row and Column Headings: ➤ Open the Page Setup window after pressing Ctrl + P + SP buttons. Steps to Print Titles (Repeat Row and Column Headers on Every Page): ➤ In the Page Setup window, specify the header row in the Rows to repeat at top: box.
➤ Check the Row and column headings option.
➤ Then go to the Print Preview option; after adjusting print settings, click on the Print option.
➤ Similarly, specify the header column in Columns to repeat at left: box.
➤ Then print it.
This article covers two different ways to print Excel sheet with rows and columns. One is to print the default Excel’s row and column headings. The other is repeating row and column headers on each page (print titles).
We’ll work on an Excel sheet called “Monthly Sales.” This sheet contains data down to row 67.
Print Excel’s Rows and Columns Headings
Here’s how to print the Excel’s default row and column headings in Excel. There are two ways to do this.
Check the Print Option from Sheet Options Group
Steps:
➤ Keep your cursor within any cell of the dataset.
➤ Go to Page Layout >> check the Print option under Headings from the Sheet Options group.
➤ Then go to the Print settings by pressing the Ctrl + P button. Excel’s row and column headings will then be visible.
However, the preview section won’t show all the data. That’s why we need to adjust some print settings.
➤ From the print area drop-down lists, choose the Print Active Sheets option.
➤ Pick the Fit All Columns on One Page option from the scaling options to print all columns.
➤ Then choose a suitable printer.
➤ Finally, print your Excel sheet data.
Use the Page Setup Window to Print Row and Column Headings
An alternative way to print Excel’s row and column headings is to use the Page Setup window.
Steps:
➤ Select all data by pressing Ctrl + A button.
➤ Go to Page Layout >> click on the Dialog Box Launcher from the Page Setup group.
➤ Or go File >> Print to open Print settings >> choose the Page Setup option.
➤ However, in the Page Setup window, go to the Sheet tab.
➤ Check the Row and column headings option.
➤ Press OK.
Now your data is ready to print.
Print Titles (Repeat Column and Row Headers on Each Page)
If your Excel sheet needs more than one page to print, you have to repeat the row and column headers (also called print titles) on each page. If so, try this approach.
Steps:
➤ Select data >> Page Layout >> Print Titles.
➤ From the Sheet tab, go to Rows to repeat at top: box and specify the header row.
➤ Choose the $1:$1 row.
➤ Similarly, specify the header column (e.g. $A:$A) in Columns to repeat at left: box.
➤ Then go to the Print settings >> click Print to proceed.
In print preview, navigating to the second page reveals that the header row is repeated at the top.
FAQ
How to print an Excel sheet on one page?
To print your Excel sheet however the paper size, go to Print Preview section >> choose the Fit Sheet on One Page option from the scaling options. Remember, this option will shrink your data to fit, which may make the text very small and hard to read.
How do I Print Excel spreadsheet with lines and Columns?
To do this, go to Page Layout >> check the Print option under Gridlines.
How to Print specific rows and Columns in Excel?
➤ Select the suitable cell range, press Ctrl + P .
➤ In the Print settings, under Settings, choose Print Selection.
➤ Click Print to proceed.
Is it possible to print column headers on every page in Excel Online?
Repeating column headers on every printed page is not a feature currently offered in Excel Online. To utilize this functionality, please use the Excel desktop application.
Wrapping Up
In this article, we explored two different ways to print Excel sheet with rows and columns. Feel free to download the practice file and share your thoughts and suggestions.
