
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 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.
ANIMATED EXAMPLE TO SET A 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
YOU MAY LIKE
- how to set page layout in excel?
- HOW TO FREEZE PANES IN EXCEL?
- HOW TO SET MARGIN, ORIENTATION AND SIZE IN EXCEL?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.