Dashed lines represent automatic page breaks, while solid lines are manual breaks. This will remove all manually added breaks and leave only Excel’s automatic ones.

Being able to view page numbers in a Microsoft Office Excel spreadsheet either on screen or in a printed layout is often very useful for users whose spreadsheet content spans multiple pages. In order ...