HOW TO USE PAGE BREAK PREVIEW IN EXCEL?

INTRODUCTION

As the Name suggest, Page Break Preview lets us to check how the Page will be printed. It shows the area which will be printed on different pages.

BUTTON LOCATION FOR PAGE BREAK PREVIEW IN EXCEL

PAGE BREAK PREVIEW BUTTON

STEPS TO USE PAGE BREAK PREVIEW IN EXCEL

This option lets the user to preview where the page will break while printing or what area will be printed on the page. A full article on setting PAGE BREAK is already present.

The full details about setting a  PAGE BREAK are HERE.

The output of the PAGE BREAK PREVIEW is something like the one shown in the picture.

The Picture shows where the page will break while printing. The area is shown with a dark blue line.

PAGE BREAK PREVIEW IN EXCEL