Show page breaks excel mac 2011

View page breaks After you open the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.

View page breaks

On the File menu, click Print. Click Cancel. Dashed blue lines appear on the sheet. Expand your Office skills. Get new features first. Was this information helpful?

Show or hide formatting marks

Yes No. Any other feedback? How can we improve it? Send No thanks.

It only takes a minute to sign up. Somehow or other I have managed to switch on the print margin lines in Excel I cannot seem to turn them off. Any ideas to get rid of them? I have Excel so I'm giving the instructions to hide page break lines for Excel , but it should be applicable to Excel as well:. For Excel , go to File, Options, Advanced.

Then page down to Display options for this worksheet and uncheck Show page breaks. Be sure you are in Display options for this worksheet and not 'this workbook'.

Move a page break

That should do it!! The fastest way I have found is to simply save your file, close and reopen. The dashed print lines should no longer be displayed.

Excel 2007: Adjust page breaks to control what is printed on each page

This will remove the background Page number" watermark. This will remove the printing dotted lines. Sign up to join this community.


  • You are here!
  • Insert a horizontal or vertical manual page break!
  • Microsoft Excel - Insert, move, or delete page breaks in a worksheet.
  • Microsoft Excel - Insert, move, or delete page breaks in a worksheet.
  • macbook - In Excel, how do you delete line breaks? - Ask Different.

The best answers are voted up and rise to the top. Home Questions Tags Users Unanswered.

How do I set/move page breaks in Excel 2011.

How to remove the print preview lines in Excel ? Ask Question. Asked 7 years, 11 months ago.


  • how to edit locked pdf files on mac.
  • atem software control download mac.
  • download adobe flash player mac os x 10.5.8!
  • ifixit mac mini dual hard drive video?
  • How to show or hide section breaks in Word?.

Active 2 years, 11 months ago. Viewed k times.

How To Remove A Page Break In Excel For Mac - ilodykuh.tk

Mark Allison Mark Allison 2 2 gold badges 10 10 silver badges 22 22 bronze badges. When you print, page breaks appear automatically where content on a sheet 'breaks' or continues to the next page. In normal view, they appear as dashed horizontal and vertical lines; in page layout view, they appear as empty spaces between the pages. You can adjust where automatic page breaks occur and add your own page breaks manually.

You can also remove manual page breaks, but you cannot remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages. Home Contact. How To Remove A Page Break In Excel For Mac January 17 By The Page Break preview feature in Excel enables you to spot and fix page break problems in an instant, such as when the program wants to split information across different pages that you know should always be on the same page. Repost 0.