Remove a manual page break. Do one of the following: To remove a. Horizontal page break. Select the row below the page break. Vertical page break. Select the column to the right of the page break. On the Page Layout tab, click Breaks, and then click Remove Page Break. Feb 12, 2019  How do I delete a dashed print line from an Excel spreadsheet? I was going to print an Excel spreadsheet, but then changed my mind. Now I cannot for the life of me get rid of a dashed vertical print line in a document.

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 Break Preview view, they appear as solid bold lines between the pages with the page number overlaid in the center. You can adjust where automatic page breaks occur, and add your own page breaks manually. You can remove manual page breaks, but you can't remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.

Page breaks as displayed in Page Break Preview view:

View page breaks

Click the View tab on the ribbon, and choose Page Break Preview.

or

Click File > Print ( P).

  1. In the Print dialog box, you can view a quick preview of how the pages will print, and use the left/right buttons to see each page.
  2. Click Cancel to close the Print dialog box.
    After you close the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.
    Note: To hide the dashed lines, click Excel > Preferences > View, and then under Show in Workbook, clear the Page breaks check box.

Insert a horizontal or vertical manual page break

  1. Do one of the following:
    To insert a
    Do this
    Horizontal page break
    Select the row underneath the row where you want the page to break.
    Vertical page break
    Select the column to the right of the column where you want the page to break.
  2. On the Page Layout tab, click Breaks, and then click Insert Page Break.

Move a page break

  1. On the View tab, click Page Break Preview.
  2. 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.
    Note: When you move an automatic page break, it changes to a manual page break. Manual page breaks are not adjusted automatically.

Remove a manual page break

  1. Do one of the following:
    To remove a
    Do this
    Horizontal page break
    Select the row below the page break.
    Vertical page break
    Select the column to the right of the page break.
  2. On the Page Layout tab, click Breaks, and then click Remove Page Break.

Remove all manual page breaks

Related Topics

Free
How To Remove Dotted Lines Excel For Mac

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 Break Preview view, they appear as solid bold lines between the pages with the page number overlaid in the center. You can adjust where automatic page breaks occur, and add your own page breaks manually. You can remove manual page breaks, but you can't remove automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size to fit the content on fewer pages.

Page breaks as displayed in Page Break Preview view:

View page breaks

Click the View tab on the ribbon, and choose Page Break Preview.

or

Click File > Print ( P).

  1. In the Print dialog box, you can view a quick preview of how the pages will print, and use the left/right buttons to see each page.
  2. Click Cancel to close the Print dialog box.
    After you close the Print dialog box, dashed lines appear on your sheet that indicate where pages will break.
    Note: To hide the dashed lines, click Excel > Preferences > View, and then under Show in Workbook, clear the Page breaks check box.

Insert a horizontal or vertical manual page break

  1. Do one of the following:
    To insert a
    Do this
    How to get google docs for mac osx free. Horizontal page break
    Microsoft outlook mail for mac. I hope you find this guide more more relevant and useful than it was before. I’ve also removed the previous introduction — I'll get straight to the point. The second details how you can make Outlook feel more like Mail, and includes some of what was previously covered in the 2010 tutorial.
    Select the row underneath the row where you want the page to break.
    Vertical page break
    Select the column to the right of the column where you want the page to break.
  2. On the Page Layout tab, click Breaks, and then click Insert Page Break.

Move a page break

  1. On the View tab, click Page Break Preview.
  2. 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.
    Note: When you move an automatic page break, it changes to a manual page break. Manual page breaks are not adjusted automatically.

Remove a manual page break

  1. Do one of the following:
    To remove a
    Do this
    Horizontal page break
    Select the row below the page break.
    Vertical page break
    Select the column to the right of the page break.
  2. On the Page Layout tab, click Breaks, and then click Remove Page Break.

Remove all manual page breaks

Related Topics