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.,

excel how can i force page break

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.

excel excel how can i force page break


You can find similar Excel Questions and Answer hereunder

1) Is it possible to use 2 labels in X-Axis of a chart (like both Month and Date, Date and Day, Date and Shift)?

2) How can I get an estimate of Standard Deviation of a sample dataset?

3) How do I get the rank of a number in a list of numbers?

4) How can I extract First Name and Last Name from a cell that has Full name?

5) How can i filter multiple columns simultaneously in Excel

6) Vlookup to return multiple values in same cell in Excel

7) How can I loop through all WorkSheets and get their names using VBA?

8) I want a formula to concatenate multiple cell values separated by a line break.

9) How do I add a shape using VBA?

10) Subtotal and sumif combination help in Excel

11) How can I get input from user through a prompt and assign user's input to a cell?

12) I want a formula to concatenate multiple cell values separated by a line break.

13) Determine if hyperlinks are valid in Excel

14) Is there a way I can average a range of numbers even if there is an error value in range?

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