How to use page break in Excel to improve your spreadsheet print outs.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Page Break in Excel
How to use the page break in Excel to improve your printing and pdf creation.
If you have a spreadsheet and you want to print it – and when you go to the Preview, you notice that something that you want to appear in one page – so here you will see a few bullet points and on the next page is the bullet point I want to appear all together on a single page. Excel has obviously decided that this page is too long and has broken it at that page. I can go back to VIEW, and most times you are looking at a spreadsheet in NORMAL VIEW – we can change it to PAGE BREAK PREVIEW and this view appears.
The grey area is the area that is not going to be printed, the white area is what is going to be printed, the solid blue lines are the page breaks. If you go down here, you’ll notice there is a dotted blue line. This dotted blue line is where Excel has forced a page break, generally due to the size of the spreadsheet. However you can control it, so if I click, hold – I can drag it down and when I let go you’ll see a solid line appears and this is now a page break that I have forced.
If we now look at the Print Preview, you’ll notice that all the bullet points are on one page and the next page is the area we want. If you need to create a page break, if you don’t have a line to drag, so, for example over here, what we can do is highlight the row, right click, and you’ll see an option called “insert page break” – if you click on it, you’ll see a line is put in – now you could move it around. And alternatively, if you want to remove it, again I click on that row, right click and you’ll see there is an option called “remove page break”.