Where can i see the page breaks before printing in Excel

For example, I have a large Table that summarizes the Population and Annual Growth Rates of all countries of the world from 1969 to 2014 (section of the table is below). I want to see where page breaks occur before I actually print.

excel where can i see the page breaks before printing

To do it in Excel, here is the answer:

a) Click on "Page Break Preview" under "View".

excel where can i see the page breaks before printing

b) Page Break Preview is displayed showing where the Page breaks occur. The Page Breaks can be dragged if required to print in a certain way.

excel where can i see the page breaks before printing

excel where can i see the page breaks before printing

 

You can find similar Excel Questions and Answer hereunder

1) How can I prevent users from seeing / accessing my macro code?

2) I want to force a page break at a certain row - how can I do that?

3) How can I add a Footer to my printout with automatic page numbering?

4) How to print a worksheet in Excel VBA

5) Is there any way I can see more region of my WorkSheet?

6) How can I access previously auto saved versions of my current Excel workbook?

7) How can I find the slab in which a given value fits?

8) How to print a worksheet in Excel

9) How can i filter multiple columns simultaneously in Excel

10) How can I make my macro wait for 5 secs before executing the next command?

 

Here the previous and next chapter