How to Create and Wrap Text in an Excel Header with WPS Office
Question details
The user wants to create a header in a WPS spreadsheet and wrap the header text across multiple lines, either for printed pages or within worksheet cells.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with a WPS spreadsheet and needs a multi-line header for a printed page or inside the worksheet.
- Observed behavior
- The header text should appear on multiple lines instead of staying on one line or being cut off.
Open the workbook and determine whether the header is for the printed page or for worksheet cells, because the wrapping steps are different in WPS Spreadsheets.
Create and wrap a printed page header in WPS Spreadsheets
Use this method when the header should appear at the top of every printed page and you want it to break across multiple lines.
Go to File > Page Setup > Header/Footer in WPS Spreadsheets.
Click Custom Header or the header box, type the header text, and press Enter to create additional lines.
Click OK and use Print Preview to verify that the header wraps as expected on the printed page.
Wrap text in a worksheet header cell with Format Cells
Use this method when the header is a row of cells inside the worksheet and the text needs to wrap within the cell instead of overflowing.
Create and Wrap Excel Header Text in WPS Office Spreadsheets
Use WPS Office Spreadsheets to add a printed page header or format worksheet header cells with Wrap Text, so multi-line headers display correctly and print as expected.
- 1. Open the workbook: Launch WPS Office Spreadsheets and open the Excel file or create a new workbook.
- 2. Set up the header: For a printed header, go to File > Page Setup > Header/Footer; for a worksheet header, select the cells and open Format Cells > Alignment.
- 3. Enable text wrapping: Check Wrap Text for worksheet cells, or use Enter to add multiple lines in the page header.
- 4. Save and share: Save the file as .xlsx to keep the wrapped header formatting compatible with Microsoft Excel.
Frequently Asked Questions
How do I create a header that appears on every printed page in WPS Spreadsheets?
Go to File > Page Setup > Header/Footer, click Custom Header, enter your text, and press Enter for multiple lines. The header will repeat on each printed page.
Why is my header text not wrapping inside the cell?
Select the header cells, press Ctrl+1 to open Format Cells, go to the Alignment tab, and check Wrap Text. If the row height is fixed, drag the row boundary or use AutoFit Row Height.
Should I merge cells before or after enabling Wrap Text?
Select the range and choose Home > Merge & Center first if you want the header to span multiple columns. Then open Format Cells > Alignment and enable Wrap Text.
Will wrapped headers created in WPS Office work in Microsoft Excel?
Yes, WPS Spreadsheets saves .xlsx files, so wrapped text, merged cells, and page header settings are preserved when the file is opened in Microsoft Excel.
How do I add multiple lines in a custom page header?
In File > Page Setup > Header/Footer, click Custom Header. In the Left, Center, or Right section, press Enter after each line of header text.
