June 15


Insert page breaks and scale an Excel worksheet for printing

By Sharyn Baines

June 15, 2018


Learn how to insert page breaks and scale an Excel worksheet for printing.

Once you have your worksheet created and formatted you may want to print it. Printing can be extremely challenging if you don’t know how to control where page breaks occur and how to fit your worksheet to print on a page so that you avoid having one row or one column printing on a following page.

The Page Setup commands allow you to set the appearance of the printed worksheet.  Many Page Setup options apply to every page of the active worksheet.

Insert a page break

Excel will automatically place page breaks into your worksheet when the data included exceeds the paper size.

You can manually over-ride the automatic placement of page breaks. Excel will allow you to insert both horizontal and vertical page breaks.

Rule to Remember: a Page Break is inserted between the selected column and the column to the left and the selected row and the row above.

Insert Horizontal page breaks

1. Select the row that will be the top row of the next page. Ensure your cell selector is in column A.

2. On the Page Layout tab in the Page Setup group select Breaks. From the drop-down list select Insert Page Break.

A dashed line appears on the screen. This line does not print; it is an on screen indication of where your page break has been set.

Excel Insert Page Break

Insert Vertical page breaks

1. Select the column that will be the left most column of the next page. Ensure your cell selector is in row 1 of the column you are inserting the page break in.

2. On the Page Layout tab in the Page Setup group select Breaks. From the drop-down list select Insert Page Break.

Hints: to insert a both horizontal and vertical page breaks first select the cell you wish to be the top left hand cell of the new page and then insert the page break. To remove a break select any cell directly under or to the right of the page break symbol, and then from the Page Layout tab select Breaks, Remove Page Break. To view page breaks for the entire worksheet, from the View tab select Page Break Preview (see below).

Scaling the worksheet to fit on a printed page

Use the ‘Scale to Fit‘ options to control how the worksheet fits on a printed page.

To change the scaling options:

  • From the Scale to fit group on the Page Layout tab use the Width and Height options to set the number of pages the data will be printed across and down. Use the Scale option to scale the data to fit on the page.

Excel Print Setup 3

  • From the File tab click the Print tab and then select suitable scaling options from the scaling options drop-down.

Excel Print Setup 4

  • From the View tab click Page Break Preview. Click and drag to move where you would like the page breaks to be placed. Excel will automatically scale the worksheet to accommodate your changes. To change back to the normal view, on the View tab click the Normal button.

Excel Print Setup 5


If you enjoyed this you may also enjoy...

How to subtract in Excel

[Watch on YouTube]  /  [Subscribe to our YouTube Channel]Let me help you learn how to subtract in Excel.   It’s simple when you’re shown how, but read to the end to make sure you understand what happens when you multiply and subtract, or divide and subtract in the same formula.   This is a tricky one, so please don’t skip over it! 

Read More

How to unhide columns in Excel

[Watch on YouTube]  /  [Subscribe to our YouTube Channel]Need a hand to unhide columns in Excel?   There are different methods or unhiding available to you, depending on the version of Excel you are using.  I’ll take you through the method that will work on any version. 

Read More

Move, Copy and Paste information in Excel

  Learn how to move, copy and paste information in Excel. Once you have mastered Cut, Copy and Paste you will find yourself shifting data around easily and reusing copied data, saving you the need to recreate the same information again. All Windows applications have access to the Windows Clipboard. This is a special area used for

Read More

Sharyn Baines

About the author

Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand. She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!