Under the ‘ Page Setup’ group, click on the ‘Print Area’ button.Click on the ‘ Page Layout’ tab from the top of the Excel window.If there are multiple print areas and you’re not sure about which cells to select, press CTRL+A to select all the cells. Select the cells that contain the dotted lines.For this, here are the steps you need to follow: If the presence of multiple print areas is the cause of the dotted lines, then you need to clear the print area.
These are not exactly ‘dotted’ lines, but are gray lines that are so light that they could pass as ‘dotted’. One possible reason you see dotted lines could be the selection of certain areas on your sheet as ‘Print Areas’.
#Excel for mac view page breaks how to#
How to Remove Dotted Lines due to Print Area Selection In this tutorial, we will go over each of the above cases one by one and show you how to remove dotted lines in Excel (or dashed lines). You might also just be seeing light colored spreadsheet gridlines that seem to look like dotted lines.Someone might have put dotted borders around cells in your sheet.It may be signaling a page break or you may be in page break view.It may be because areas of your sheet were selected as ‘ Print Areas’.Here are some common reasons you might be seeing dotted lines on your Excel worksheet: But in order to remove them, you need to first diagnose why you are seeing them (or where they’re coming from). It can sometimes be quite a source of annoyance. There may be a number of reasons you see dotted (or dashed) lines on your Excel screen.
Whatever the case, we will try to tackle it step by step so as to help you find the solution. The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line.
0 kommentar(er)
