#Remove print lines excel 2016 how to#

#Remove print lines excel 2016 how to#

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.

You can always ask an expert in the Excel Tech CommunityВ or get support in the Answers community.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. To remove a border, select the cells with the border and click the Borders arrow > No Border. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 will acquire a left border.Д¬lick the arrow next to Borders, and then click the Inside Horizontal Border If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. To apply that style, click the Borders button (not the arrow). You'll also learn how to change the default color and print these gridlines in Excel. The Borders button shows the most recently used border style. In this tutorial, you'll learn how to remove gridlines in Excel. Click Home > the Borders arrow, and then pick the border option you want.ДЄdd a border color - Click the Borders arrow > Border Color, and then pick a colorДЄdd a border line style - Click the Borders arrow > Border Style, and then pick a line style option. Select the checkbox next to the Print option under Gridlines. Go to the Page Layout tab in the Ribbon interface. If no unselected sheet is visible, right-click the tab of any selected sheet, and then click Ungroup Sheets. Select the cell or range of cells that you want to add a border around, change the border style on, or remove a border from.Дў. Tip: Click any unselected worksheet to cancel the selection of more than one worksheet. Under Border, in the preview diagram, remove the vertical border by clicking it.ДЄdd a border, border color, or border line style Select the rows on both sides of the page break.Д¬lick the arrow next to Borders, and then click More Borders. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border.

If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5. If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed.ДЄ selected range of cells is formatted as a single block of cells. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 acquire a left border. You can click the Borders button (not the arrow) to apply that style. The Borders button displays the most recently used border style. To remove cell borders, click the arrow next to Borders, and then click No Border. Two diagonal border buttons are available under Border. Under Presets and Border, click one or more buttons to indicate the border placement. In the Format Cells dialog box, on the Border tab, under Line and Color, click the line style and color that you want. Tip:В To apply a custom border style or a diagonal border, click More Borders.