Description
In this video I'll show you how to remove the dotted lines in Microsoft Excel. Those dotted lines usually show up after you print or open Print Preview, and they mark where Excel will break your sheet into pages. They don't print, but they can be distracting while you work.
Timestamps:
Introduction: 0:00
Hide Page Break Lines: 0:20
Remove Other Dotted Lines: 1:17
Conclusion: 1:49
Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/
Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join
#excel #microsoftexcel #exceltutorial #techtips #tutorial
Video Transcript:
Step 1. Open your Excel spreadsheet. For this example, I'm using an inventory sheet for a comic book shop that's wide enough to need several printed pages, so a dotted page break line shows up between the columns.
Step 2. Click "File" in the top left corner of the screen, and then click "Options" at the bottom of the menu on the left side of the screen. The Excel Options window opens.
Step 3. Click "Advanced" in the menu on the left side of the window.
Step 4. Scroll down to the Display options for this worksheet section, and uncheck the "Show page breaks" box.
Step 5. Click "OK." The dotted lines disappear from your sheet. This setting only applies to the current worksheet, and the lines may come back the next time you print or open Print Preview, so you can repeat these steps whenever you need to.
If you're seeing a moving dotted line around some cells, that's just Excel showing what you've copied. Press "Escape" on your keyboard to clear it. If faint lines show up around every cell, those are gridlines, and you can hide them by clicking the "View" tab and unchecking the "Gridlines" box. And if the dotted lines are part of a cell border, select the cells, click the arrow next to the "Borders" icon on the Home tab, and then click "No Border."
