Printing Problems

How to Print an Excel Selection and Headings on One Page

Maira MehtabMaira Mehtab Nov 11, 2026 869 views

Question details

The user needs to print a specific selected range of data in an Excel spreadsheet along with its corresponding headings on a single printed page.

How to Print an Excel Selection and Headings on One Page
Product
Excel
Device & OS
not provided
Scenario
Preparing a spreadsheet for printing where only a specific data range is needed, but context from the headings is required for readability.
Observed behavior
The goal is to configure page layout and print area settings to ensure the selected cells and headings are scaled and positioned to fit perfectly on one printed page.
Before you start

Ensure your printer is correctly connected and selected in the print dialog. Identify whether the headings you need are the standard Excel grid headings (A, B, 1, 2) or custom row/column titles within your spreadsheet data.

Solution 1Recommended

Set Print Area, Enable Print Titles, and Adjust Scaling

This is the standard and most effective method to ensure a specific selection and its custom data headings print together on one page.

This method is ideal when you have specific data headers (like 'Revenue' or 'Date') that must remain visible above a selected subset of your data.

1
Select Print Area

Highlight the range of cells you want to print. Go to the 'Page Layout' tab on the ribbon, click 'Print Area', and select 'Set Print Area'.

2
Set Print Titles (Headings)

On the 'Page Layout' tab, click 'Print Titles'. In the Page Setup dialog box, click into the 'Rows to repeat at top' or 'Columns to repeat at left' field, then select the row(s) or column(s) containing your data headings.

3
Fit to One Page

Still in the 'Page Layout' tab, locate the 'Scale to Fit' group. Set both the 'Width' and 'Height' dropdowns to '1 page'.

4
Preview and Print

Press Ctrl + P to open the Print Preview. Verify that the selection and headings appear properly scaled on a single page, then click 'Print'.

Set Print Area, Enable Print Titles, and Adjust Scaling
Print Quality Tip: If your selected range is very wide, consider changing the page orientation to Landscape in the Page Layout tab to improve text readability on the printed page.
Effortless Spreadsheet Printing

Print Custom Selections and Headings Easily with WPS Spreadsheet

WPS Office provides an intuitive and free alternative to easily configure page setup, print areas, and scaling to ensure your data prints exactly as intended.

  1. 1. Open your file: Launch WPS Spreadsheet and open your Excel workbook.
  2. 2. Set the Print Area: Highlight the data you wish to print. Go to the 'Page Layout' tab, click 'Print Area', and choose 'Set Print Area'.
  3. 3. Configure Headings and Scaling: Click 'Print Titles' to configure repeating rows or columns. Then, set 'Width' and 'Height' to '1 page' under the Scale to Fit options on the ribbon.
  4. 4. Print: Press Ctrl + P, preview your document to ensure everything fits perfectly, and click 'Print'.
Set print areas, titles, and scale-to-fit settings with just a few intuitive clicks.Fully compatible with Microsoft Excel (.xlsx, .xls) files and print configurations.Built-in Print Preview allows for instant adjustments to margins and orientations.Lightweight, feature-rich, and completely free to use.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my print selection cut off and print on multiple pages?

This happens when the selected range exceeds the default page margins and scaling size. To fix it, go to the Page Layout tab and change the scaling option to 'Fit Sheet on One Page' or manually set the width and height dropdowns to 1 page.

Can I print non-adjacent selections on the same page?

By default, Excel prints non-adjacent selections on separate pages. To print them on one page, you can either hide the columns or rows between the selections before printing, or copy the specific ranges into a new, blank sheet arranged closely together.

How do I hide the gridlines when printing my selection?

To remove gridlines from your printed page, navigate to the 'Page Layout' tab, find the 'Sheet Options' group, and uncheck the 'Print' box under the 'Gridlines' heading.

What is the difference between Print Titles and Row/Column Headings?

'Print Titles' allows you to select and repeat your custom data headers (like 'Sales', 'Date', or 'Region') at the top or side of every printed page. 'Row/Column Headings' refers specifically to Excel's default interface grid labels (A, B, C for columns and 1, 2, 3 for rows).