Delete Hidden Columns and Repeat Print Headings in WPS Office Spreadsheets
Question details
The user needs to remove hidden columns, repeat header rows on printed pages, and adjust the worksheet layout so it fits the page more effectively.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is preparing an Excel-compatible worksheet for printing and wants to clean up hidden columns, repeat headings, and improve page layout.
- Observed behavior
- Hidden columns remain in the worksheet, header rows are not set to repeat on printed pages, and the worksheet may not fit the page effectively.
Make sure the worksheet is not protected and that you have permission to change the workbook structure. In WPS Office Spreadsheets, protected sheets can block Unhide, Delete, and Page Layout changes.
Delete Hidden Columns in a WPS Office Spreadsheet
Use this solution when you need to remove hidden columns before printing or cleaning up the workbook.
In the WPS Office Spreadsheets worksheet, look at the column letters. Click the letter of the column immediately to the left of the hidden columns, then hold Shift and click the letter of the column immediately to the right to select the surrounding columns.
Right-click the selected column letters and choose Unhide from the context menu. The hidden columns become visible.
Select only the columns you want to remove, right-click the selected column letters, and choose Delete. The columns are removed from the worksheet.
Repeat Header Rows on Every Printed Page
Use this solution when the header row should appear at the top of each printed page.
Fit the Worksheet to the Printed Page
Use this solution when the worksheet is too wide or too long and you need it to fit on fewer pages.
Use WPS Office Spreadsheets to Delete Hidden Columns and Set Print Titles
WPS Office Spreadsheets includes the same Page Layout and Print Titles controls as Excel, so you can remove hidden columns, repeat header rows, and scale the sheet for printing without changing the file format.
- 1. Open the workbook in WPS Office Spreadsheets: Download and launch WPS Office, then open the Excel .xlsx workbook directly in WPS Office Spreadsheets.
- 2. Delete hidden columns: Select the columns on both sides of the hidden area, right-click and choose Unhide, then select the unwanted columns, right-click and choose Delete.
- 3. Set rows to repeat at top: Go to Page Layout > Print Titles, open the Sheet tab, and select the header row under Rows to repeat at top.
- 4. Fit the page and print: Use Page Layout > Orientation, Margins, and Scale to Fit to set Landscape, Narrow margins, and Width to 1 page, then click Print Preview.
Frequently Asked Questions
How do I unhide all hidden columns at once in WPS Office Spreadsheets?
Click the Select All button at the corner between row 1 and column A, right-click any column letter, and choose Unhide. If the sheet is protected, unprotect it first.
Why don’t my header rows repeat on every printed page?
The likely reason is that no row is set under Page Layout > Print Titles > Rows to repeat at top. Set the header row there, then check File > Print Preview.
Can I delete hidden columns without unhiding them first?
In normal WPS Office Spreadsheets use, hidden columns must be unhidden before you can select and delete them. Select the surrounding columns, right-click, choose Unhide, then delete the unwanted columns.
How do I make a wide Excel sheet fit on one printed page?
Use Page Layout > Orientation and choose Landscape, set Margins to Narrow, and in Scale to Fit set Width to 1 page. Check the result in File > Print Preview.
