Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What is Page break Preview in Excel?

user-image
Question ajoutée par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date de publication: 2013/12/09
Zafar Iqbal
par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

In page break preview we can see the printing view of excel sheet.

Mohammed Yaseen MBA  PMP®
par Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

To print a worksheet with the exact number of pages that you want, you can adjust the page breaks in the worksheet before you print it. Although you can work with page breaks in Normal view, we recommend that you use Page Break Preview view to adjust page breaks so that you can see how other changes that you make (such as page orientation and formatting changes) affect the automatic page breaks. For example, you can see how a change that you make to the row height and column width affects the placement of the automatic page breaks.

To adjust page breaks, you can insert your own page breaks, move existing page breaks, or delete any manually-inserted page breaks. You can also quickly reset all page breaks to automatic page breaks. After you finish working with page breaks, you can return to Normal view.

Muhammad Faheem
par Muhammad Faheem , Consultant- Accounts, Audit & Taxation , Basim Associates

Page break preview option make your view a preview of where page will break during printing.

click the view tab and go to the workbook views group to view the page break preview button in excel2007.

 

FAIZA MAHREEN BANGASH
par FAIZA MAHREEN BANGASH , INTERNEE , BANK OF KHYBER

Page break preview option show you where will page break down, and another page will start.

 

rathesh nair
par rathesh nair , Group IT Head , Aayush Group of Hospital

To print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page breaks. In this view, manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break pages automatically.

  1. On the View menu, click Page Break Preview.
  2. Do one of the following:
  • To move a page break, drag the page break to a new location.

 NOTE   Moving an automatic page break changes it to a manual page break.

  • To insert a vertical or horizontal page break, select a row or column below or to the right of where you want to insert the page break, right-click, and then click Insert Page Break.
  • To remove a page break, drag the page break outside of the page break preview area.
  • To remove all manual page breaks, right-click any cell on the worksheet, and then click Reset All Page Breaks.

AfaqUe Muhammed
par AfaqUe Muhammed , Office Administrator , Bulzai Trading LLC

To veiw the exact printing page from your excel sheet ...

Ali Hyder Khoyee
par Ali Hyder Khoyee , Global Care Business Partner , Maersk

print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page break.

More Questions Like This