where can I see the page breaks before printing in Excel
Q129. In Excel, how can I see where page breaks occur before actually printing?
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.
To do it in Excel, here is the answer:
a) Click on "Page Break Preview" under "View".
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.