There are situations when you need to print your Excel worksheets. You can always do this as the print feature is always available in MS Excel.
The problem most likely that you will encounter is on how do you configure the number of pages. MS Excel can help you achieve this by applying page breaks.
With this feature, you can set the number of pages you want printed before printing your worksheet.
- An example of a worksheet with page breaks
There are two ways on how you can insert page breaks in your worksheet.
2 Ways to Insert Page Breaks in MS Excel
- Inserting a page break using the Page Layout tab
- Inserting a page break using the Right-click context menu
There are two types of page breaks—vertical and horizontal. This article will guide you on how you can insert them to your worksheets using the methods specified above. Before learning the steps, it is important to understand the difference between these two types. The vertical page break divides your worksheet into vertical sections. In contrast, the horizontal page break divides your worksheet into horizontal sections.
The number of sections created by these breaks will be the number of pages when you print your worksheet. Now, it’s time for you to learn how to insert them.
Let’s get started!