PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

HOW TO insert page break and background IN EXCEL?

INTRODUCTION

After the completion of reports, the next and final step is to print the report and present it.

PAGE BREAK is another option which help us to print the report as the way we want.

Page breaks are used to create a break in the page. Page breaks are used to custom print the areas if we don’t want the whole page to be printed.

It shows where a new page will start printing. The part pages will be printed as such.

The button for inserting page break and background is located under the PAGE LAYOUT TAB under the PAGE SETUP section.

Have a look at the picture shown above.

Select the cell where you need a page break.
The area will be broke at the point left to the selected cell and above the selected cell as shown in the picture.
Go to PAGE LAYOUT tab>Page setup> BREAKS
Select INSERT PAGE BREAK.
A dotted line will show the area to be printed.

This option lets you choose a picture file to be set as background of the sheet. It is again used to change the look and feel of the sheet.

STEPS:

The picture below shows the process of inserting a backgroud in the EXCEL SHEET.

If we want to use any picture as a watermark, we can use a transparent image for the same as in the following picture.