When you take a Microsoft Excel worksheet into "Print Preview" mode to see how it will look when you print it, you will see a number of lines representing page breaks. Dotted lines denote automatic page breaks inserted by Excel and unbroken lines show page breaks that you have inserted manually. When you return to "Normal" mode to continue working, you may still see these lines as the "Show Page Breaks" option will have turned on automatically. You can remove the preview lines by changing the display settings.
- Skill level:
Other People Are Reading
Click the "View" tab, then click "Normal" in the "Workbook Views" section. You can also click the "Normal" button on the status bar. This looks like a grid of blank worksheet cells.
Click the Microsoft Office button. This is the button that shows the Microsoft logo. Click "Excel Options," then click the "Advanced" tab.
Scroll down to the "Display options for this worksheet" section. Click to clear the "Show Page Breaks" tick-box. The print preview lines will be removed.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for