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.

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 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 excel excel where can i see the page breaks before printing

excel excel excel excel where can i see the page breaks before printing

 

You can find similar Excel Questions and Answer hereunder

1) How can I export a chart as a gif file?

2) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

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

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

5) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

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

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

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

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

10) How to center excel sheet horizontally and verticaly on page in Excel

11) How to read a value from a cell in vba in Excel

12) How can I set up a drop down list?

13) How can I get the most frequently occurring text in a range?

14) Is there a way to get a log value of a number using Excel?

15) Vba clear the contents of an entire sheet in Excel