Printing Problems

How to Use Multiple Print Titles on One Worksheet in Excel

WPS Content Manager Oct 9, 2026 869 views

Question details

The user wants to know if it is possible to set different repeated print titles for multiple distinct sections within the same Excel worksheet.

Can Excel Use Multiple Print Titles on One Worksheet?

Product: Excel / WPS Spreadsheet
Device & OS: not provided
Scenario: Printing a large report with multiple sections on a single worksheet that require different header rows.
Observed behavior: The built-in Print Titles feature only applies one set of repeated rows or columns to the entire worksheet, failing to natively support varied titles for different printed sections on the same sheet.

Before you start

Review your worksheet layout to determine if your data can be logically separated into different sheets before adjusting your advanced print settings.

Solution 1Recommended

Move Report Sections to Separate Worksheets

The most effective way to use different print titles is to separate your data sections into individual worksheets, allowing unique page setups for each.

Excel's Print Titles feature applies to the entire worksheet globally. By splitting your report into multiple sheets, you can independently assign the correct repeating header rows to each section.

Add a new worksheet

Click the '+' icon at the bottom of your workbook to create a new worksheet for your second report section.

Move the data

Cut and paste the distinct section of your data from the original worksheet into the newly created sheet.

Configure Print Titles

Go to the 'Page Layout' tab, click 'Print Titles', and open the Page Setup dialog. Under 'Rows to repeat at top', select the specific header row for this new worksheet and click OK.

Repeat for other sections

Perform these steps for any additional sections, allowing each sheet to maintain its own unique repeated print title.

Move Report Sections to Separate Worksheets

Printing the Full Report: You can still print all sections at once by holding 'Ctrl', selecting all the relevant sheet tabs, and then choosing 'Print Active Sheets' in the print menu.

Solution 2

Insert Manual Page Breaks and Inline Titles

If you must keep all data on one worksheet, you can manually design the print layout by inserting page breaks and copying header rows.

Manage Print Layouts Easily

Easily Manage Print Settings with WPS Spreadsheet

WPS Spreadsheet provides an intuitive Page Layout interface, making it simple to configure print titles, page breaks, and custom print areas for complex reports without the hassle.

1. Open your file: Launch WPS Spreadsheet and open your multi-section report.
2. Navigate to Page Layout: Click on the 'Page Layout' tab on the top ribbon menu.
3. Select Print Titles: Click on the 'Print Titles' button to open the Page Setup dialog box.
4. Set repeating rows: Click the selection arrow next to 'Rows to repeat at top' and highlight the row you want to repeat.
5. Preview and print: Click 'Print Preview' to verify your layout is correct before sending the document to the printer.

Easily set rows and columns to repeat on printed pagesFully compatible with Microsoft Excel (.xlsx) files and print setupsIntuitive print preview and page break management toolsFree, lightweight, and fast office suite

microsoft office alternative - wps office

Frequently Asked Questions

Can I set multiple print areas on one worksheet?

Yes, you can hold the Ctrl key and select multiple non-adjacent ranges, then go to Page Layout > Print Area > Set Print Area. However, note that all of these print areas will still use the same Print Title settings if configured.

Why is the Print Titles option grayed out?

The Print Titles option is often grayed out if you are currently editing a cell, editing a chart, or if multiple worksheets are grouped together. Press 'Enter' to finish editing, or right-click a sheet tab and select 'Ungroup Sheets' to fix this.

Do Print Titles show up in the normal worksheet view?

No, Print Titles only appear when you print the document or view it in Print Preview mode. They do not duplicate rows in the standard editing view.

Document & File Issues