If they are light grey in color, then you are in Normal view (as shown below). If the dotted lines are blue in color, then you are in Page Break view (as shown below). It’s also important to note the color of the lines. Manually added page breaks are shown as solid lines while automatic page breaks are shown as dotted lines. Quite possibly you might have tried to print something earlier, which caused these dotted lines to demarcate page breaks in your sheet. A page break is a dotted line that defines where one page ends and the next one starts.
#FOR SOME REASON MY MAC EXCEL SHEET HAS TWO PAGES HOW TO#
How to Remove Dotted Lines due to Page BreaksĪnother reason for the dotted lines may be the presence of page breaks. This will cause all print areas in your selection to be removed.ĭid this solve your problem? If not, then it’s probably not the print area that’s causing the dotted lines. Select the ‘Clear Print Area’ option from here. 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’. 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)
