Bỏ Page Break Trong Excel 2010, Insert, Move, Or Delete Page Breaks In A Sheet

Excel for nghiencongnghe.org 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More...Less

When you print, page breaks appear automatically where nội dung on a sheet "breaks" or continues lớn the next page. In normal view, they appear as dashed horizontal & 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 sầu automatic page breaks. However, you can adjust column widths or margins, or scale the sheet size khổng lồ fit the content on fewer pages.

Bạn đang xem: Bỏ page break trong excel 2010

Page breaks are displayed in Page Layout View.

Newer versionsOffice 2011


View page breaks

To xem trang breaks using Page Break Preview:

On the status bar, click the Page Break PĐánh Giá button.

Or, cliông chồng the View tab, then cliông chồng the Page Break Preview button.

Insert a horizontal or vertical manual page break

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 khổng lồ break.
Vertical page break	Select the column that is lớn the right of the column where you want the page to break.

On the Page Layout tab, in the Page Setup group, cliông xã Breaks, và then cliông xã Insert Page Break.

Move a page break

On the View thực đơn, cliông chồng Page Break Preview.

Rest the pointer on the page break line until the pointer changes khổng lồ a , and then drag the page break line lớn a new location.

Note: When you move an automatic page break, it changes lớn a manual page break. Manual page breaks are not adjusted automatically.

Remove a manual page break

Do one of the following:

To remove sầu a

Do this

Horizontal page break	Select the row below the page break.
Vertical page break	Select the column to lớn the right of the page break.

On the Page Layout tab, in the Page Setup group, cliông chồng Breaks, và then cliông xã Remove Page Break.

Remove sầu all manual page breaks

On the Page Layout tab, in the Page Setup group, click Breaks, và then cliông chồng Reset All Page Breaks.

View page breaks

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

On the File menu, clichồng Print.

Xem thêm: Danh Sách Các Hàm Toán Học Trong Excel Ngày 08/08/2017, Các Hàm Toán Học Thông Dụng Trong Excel

In the Print dialog box, you can view a quick pnhận xét of how the pages will print.

Clichồng Cancel.

Dashed xanh lines appear on the sheet.

Note: To hide the dashed blue lines from sight, on the Excel thực đơn, clichồng Preferences, click View, và then clear the Show page breaks check box.

Insert a horizontal or vertical manual page break

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 lớn the right of the column where you want the page to lớn break.

On the Layout tab, under Page Setup, clichồng Breaks, & then cliông chồng Insert Page Break.

Move a page break

On the View thực đơn, cliông xã Normal.

Rest the pointer on the page break line until the pointer changes to a , & then drag the page break line khổng lồ a new location.

Note: When you move an automatic page break, it changes lớn a manual page break. Manual page breaks are not adjusted automatically.

Remove a manual page break

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.

On the Layout tab, under Page Setup, clichồng Breaks, & then click Remove Page Break.

Remove sầu all manual page breaks

On the Layout tab, under Page Setup, click Breaks, & then clichồng Reset All Page Breaks.

Need more help?

You can always ask an expert in the Excel Tech Community or get tư vấn in the Answers community.

Was this information helpful?

YesNo
Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Other
Didn't match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Other
Any additional feedback? (Optional)
Submit feedback