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

Contents

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.

 

BUTTON LOCATION TO INSERT PAGE BREAK AND BACKGROUND

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

STEPS TO CREATE A PAGE BREAK IN EXCEL

STEPS TO INSERT A PAGE BREAK

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.

HOW TO INSERT BACKGROUND IN EXCEL?

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 TO SET A BACKGROUND IN EXCEL

STEPS:

  • Look at the picture given below.
  • Click on BACKGROUND BUTTON.
  • FILE CHOOSING DIALOG BOX will open.
  • Select the picture and it’ll be set as background.
BUTTON LOCATION FOR BACKGROUND BUTTON

ANIMATED EXAMPLE TO SET A BACKGROUND IN EXCEL

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

SETTING BACKGROUND IN EXCEL
ANIMATED EXAMPLE:SETTING BACKGROUND

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

BACKGROUND IN EXCEL
BACKGROUND IN EXCEL

OTHER WAYS TO REACH THIS ARTICLE

  • PAGE BREAK IN EXCEL, WHERE TO BREAK THE PAGE, SET PRINT AREA IN EXCEL, CHANGE BACKGROUND IN EXCEL, BACKGROUND OF SHEET

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: