worddemo.blogg.se - Remove blue lines in excel for mac 2011

REMOVE BLUE LINES IN EXCEL FOR MAC 2011 HOW TO

If it’s a whole range of cells, then select the range of cells the border encompasses.

Select the cells that contain the dotted lines.

In any case, if the lines are there due to a border setting, removing them is a piece of cake. Possibly someone who had worked on the sheet before you had put it there or you might have accidentally selected a dotted border option.īelow is how the dashed border would look like:Īnd below is how the dotted border would look like:

REMOVE BLUE LINES IN EXCEL FOR MAC 2011 HOW TO

How to Remove Dotted Lines due to Dotted/ Dashed Cell BordersĪ third reason you see the dotted lines might be the presence of dashed/ dotted cell borders. In that case, we would suggest you keep reading. If not, then maybe there’s some other reason. If your dotted lines were, in fact, due to page breaks, then they should disappear after these steps. Click OK to close the Excel Options dialog box.Uncheck the ‘ Show page breaks’ checkbox.Scroll down to ‘ Display options for this worksheet’ section.This will open the Excel Options dialog box.If not, then you need to click on the File menu and navigate to Options. If this successfully removed the dotted lines, you can stop here.For this, simply click on the View tab and select ‘Normal’ from the ‘ Workbook Views’ group. If you are in Page Break view, then first try shifting to Normal view.Once you have determined which view you are in, you can proceed to remove the dotted lines. 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.

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. 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.