Remove page break lines excel mac

One formatting technique involves adding borders. Selecting the Home tab at the top of the screen reveals the Font section on the ribbon.


  • Insert, move, or delete page breaks in a sheet - Excel for Mac?
  • surgeon simulator 2013 mac not working.
  • download widget mac for windows 7.
  • ipod charging but not showing up in itunes mac?

Clicking the Borders drop-down button gives you an extensive list of border options for the currently selected cell or range of cells. If your current borders are dotted lines, you can turn off borders or select a style other than dotted lines for the cell borders. An Excel page break problem can also create unexpected dotted lines. When you have a spreadsheet formatted to print, page breaks are represented horizontally by lines.

In the current version of Excel for Office , a manually added page break shows as a solid horizontal line, while automatically generated page breaks show as dotted lines.

Insert, move, or delete page breaks in a sheet

To remove a single manually added page break in Excel, select a cell in the row immediately below the primary page break. Click on Breaks and select Remove Page Break. In Normal View, the solid horizontal line disappears. However, the dotted lines of automatically generated page breaks remain.

Insert a horizontal or vertical manual page break

Remove these using the following steps:. With degrees in Photography and Recorded Music Production, Scott spent over 20 years as an Operations Manager with Kodak before starting a second career as a freelance content creator specializing in business, accounting and tax topics. Skip to main content. Digital Vision. Tip These techniques may also work with older versions of Excel. References 3 Microsoft Office Support: Insert, move, or delete page breaks in a worksheet Microsoft Office Support: Apply or remove cell borders on a worksheet Microsoft Office Support: After you close the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.

On the View tab, click Page Break Preview.

Microsoft Excel - Insert, move, or delete page breaks in a worksheet

Rest the pointer on the page break line until the pointer changes to a , and then drag the page break line to a new location. When you move an automatic page break, it changes to a manual page break.

How to set and delete Page Breaks in Microsoft Excel 2013

Manual page breaks are not adjusted automatically. Scale the sheet size for printing. Expand your Office skills.

Page Break Preview in Excel ...

Get new features first. Was this information helpful? Yes No. Any other feedback? How can we improve it?


  • How to Get Rid of a Dotted Line in Excel!
  • Create manual page breaks in a worksheet with Excel for Mac.
  • expression encoder for mac download.
  • no arranca desde usb mac.
  • create video slideshow with music mac.

Send No thanks. Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.