Prisijunkite prie „Microsoft“
Prisijunkite arba sukurkite paskyrą.
Sveiki,
Pasirinkti kitą paskyrą.
Turite kelias paskyras
Pasirinkite paskyrą, kurią naudodami norite prisijungti.
Anglų
Atsiprašome, tačiau šis straipsnis neprieinamas jūsų kalba.

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.

Page breaks are displayed in Page Layout View.

View page breaks

To view page breaks using Page Break Preview:

  1. On the status bar, click the Page Break Preview button.

  2. Or, click the View tab, then click the Page Break Preview button.

    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 that is underneath the row where you want the page to break.

    Vertical page break

    Select the column that is to the right of the column where you want the page to break.

  2. On the Page Layout tab, in the Page Setup group, click Breaks, and then click Insert Page Break.

    Options on the Breaks menu

Move a page break

  1. On the View menu, click Page Break Preview.

  2. Rest the pointer on the page break line until the pointer changes to a Horizontal page break handle, 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, in the Page Setup group, click Breaks, and then click Remove Page Break.

    Options on the Breaks menu

Remove all manual page breaks

  • On the Page Layout tab, in the Page Setup group, click Breaks, and then click Reset All Page Breaks.

    Options on the Breaks menu

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Scale the sheet size for printing

Set page margins

Print part of a sheet

Preview pages before you print

Reikia daugiau pagalbos?

Norite daugiau parinkčių?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ar ši informacija buvo naudinga?

Kas turėjo įtakos jūsų įspūdžiams?
Paspaudus mygtuką Pateikti, jūsų atsiliepimai bus naudojami tobulinant „Microsoft“ produktus ir paslaugas. Jūsų IT administratorius galės rinkti šiuos duomenis. Privatumo patvirtinimas.

Dėkojame už jūsų atsiliepimą!

×