how can I force page break in Excel
Q130. I want to force a page break at a certain row - how can I do that?
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 print each section of the Table in its own page - like North America, Latin America, Asia, Europe etc.,
To do it in Excel, here is the answer:
a) Click on "Breaks" under "Page Layout". To print "Latin America" section in its own page, click on the cell from which new page should start as shown below. Click on "Insert Page Break".
Repeat the process for each section that has to be printed in its own page.