How to Fix Excel Rows Inserting Incorrectly Near a Page Break
Question details
The user needs to correct data misalignment caused when inserting rows near an automatic page break in a spreadsheet.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Adding new data or adjusting the layout of a spreadsheet near a page break.
- Observed behavior
- Only part of a worksheet row moves when inserting new data, causing cells to become misaligned across the columns.
Ensure you do not have any active filters applied to your data, and verify whether you previously selected 'Insert Cells' instead of 'Insert Entire Row', as shifting partial cells is the most common cause of layout misalignment.
Insert Entire Worksheet Rows Instead of Cells
Prevent data misalignment by ensuring you select and insert a complete worksheet row rather than just shifting a selection of cells downward.
Misaligned data usually results from inserting individual cells. When you insert full sheet rows, the structural integrity of the entire worksheet is maintained, preventing parts of the row from shifting irregularly near page breaks.
Click the row number on the left side of your worksheet to highlight the complete row where you want to add space.
Right-click the highlighted row number and select 'Insert' from the context menu, or choose 'Insert Sheet Rows' from the Home tab on the ribbon.
Alternatively, select any cell in the target row, press 'Shift + Spacebar' to select the entire row, and then press 'Ctrl + +' (Control and the Plus key) to insert a new row.

Adjust or Ignore Page Breaks
If the page break is awkwardly splitting your rows for printing purposes, you can manually adjust its position or ignore it entirely.
Easily Manage Rows and Page Breaks in WPS Spreadsheet
WPS Office offers a robust, free spreadsheet tool that seamlessly handles row insertions, data alignment, and print layouts. Avoid frustrating cell shifts with its intuitive design.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet document.
- 2. Select the target row: Click the row number on the left edge of the screen to select the entire row.
- 3. Insert a new row: Right-click the row number and choose 'Insert' to add a complete new row without misaligning your data.
- 4. Manage Print Layouts: Go to the 'View' tab and select 'Page Break Preview' to easily drag and adjust where your pages separate.

Frequently Asked Questions
Why does inserting a row shift only part of my data?
This happens when you have highlighted specific cells and chosen 'Insert Cells' (shifting cells down) instead of inserting an entire sheet row. Always select the row number on the left margin to ensure the whole row is inserted.
What is the keyboard shortcut to select an entire row?
You can select an entire row by clicking any cell within that row and pressing 'Shift + Spacebar' on your keyboard.
How do I hide or ignore page breaks if I am not printing the file?
If you do not plan to print the worksheet, you can safely ignore page breaks. To remove the distracting dashed lines, go to 'File' > 'Options' > 'Advanced', scroll down to 'Display options for this worksheet', and uncheck 'Show page breaks'.
Can page breaks cause data to be deleted?
No, page breaks only dictate where a page ends when printing. They do not delete or modify your underlying cell data.




