How to use page breaks for perfect printing?

image_pdf

Insert a page break in Excel to specify where a new page will begin in the printed copy. You can adjust the page breaks in the worksheet before you print.

Steps to set Page Breaks:

1. Open the worksheet. Click view menu, in Workbook Views group, click on Page Break Preview. Excel will open workbook in Page break preview mode. You can see the highlighted blue dotted line which show default page break

Workbook views

Shortcut: Select Page preview button at the bottom of the page near Zoom bar.

2. To change the length of page for printing, select row below where you want to insert the page break.

2014-08-23 17_42_09-Microsoft Excel - KAMALji 5 jan-1

3. Go to Page Layout Menu, in page setup group, click on breaks and from drop down list select Insert Page Break.

Insert page break

Result:

2014-08-23 17_53_24-Microsoft Excel - KAMALji 5 jan-1

4. Same way to change the width of page for printing, Select the column right where you want to insert the page break.

Insert column page break

5. Go to Page Layout Menu, in page setup group, click on breaks and from drop down list select Insert Page Break.

Result: New page break will be added to the page.

Page Break

Now your page size is perfect for printing. Press Ctrl +P or Go to File-> Print to print preview the document. You may need to change the Page orientation to Landscape from Portrait to see the change in page width.

To see the Normal View of Page, click on Normal View at the bottom of the page near Zoom bar.

Remove Page Break

To remove break do the same process same as above (Select row or column which is below or right to the page break), Go to Page Layout Menu, in page setup group, click on breaks and from drop down list select remove page break.

Remove Page Break

Reset all Page Breaks:

To reset all page breaks you can click on the Page Layout Menu, click on break and from drop down list select Reset All Page Breaks.

Reset Page Breaks

If you find this useful, you can stay connected with us on facebook to get more amazing tips and tricks of Microsoft excel.

 

 

3,492 total views, 6 views today

2 thoughts on “How to use page breaks for perfect printing?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>