Background image is the visual, which is visible in the background of the cells in Excel.
There can be many situations when we need the backgrounds in our reports.
They can be helpful in complementing the looks of our report or we can insert any picture to show the owner details or any other information, which we also know as a watermark. [ CLICK HERE TO LEARN HOW TO INSERT A WATERMARK IN EXCEL SHEET ].
If you are familiar with Excel and have inserted a background , then you must be knowing that while printing, EXCEL PRINTS ONLY THE CONTENT OF THE CELLS, objects and nothing except that.
NO BACKGROUND IS PRINTED IN THE EXCEL SHEET.
So, we need to use several tricks to make it possible and get the background printed on our sheet.
In this article, we’d learn to print the background in Excel.
You got it right.
You can’t print the so called BACKGROUND in Excel, the option we find under the PAGE LAYOUT Tab.
Excel lets you print the content of the cells, grid lines or any objects which you have added. Other than that, nothing will be printed.
This is the reason why such tricks are needed to be used.
Let us find out the tricks to make the background printable.
We can make the background image printable in mainly two ways.
Follow the steps to create a printable background in EXCEL 2019. [ The reference pictures are of Excel 2019. The steps are same but option locations can be different ]
The following picture shows the location of the button.
ALWAYS REMEMBER, WHEN WE GO BACK TO THE NORMAL VIEW I.E. THE SHEET VIEW, HEADER OR FOOTER IS NEVER VISIBLE THERE. EVEN IF THE HEADER OR FOOTER IS A PICTURE IT WON’T BE VISIBLE IN THE NORMAL OR SHEET VIEW.
The following picture is visible in the background and will be printed when the page is printed.
This background will be available in all the pages of the excel workbook and will be printed when we print the workbook.
We already created a printable background.
What if we want some changes in the picture.
Don’t Worry !
We can change the picture. If it is color , transparency etc. we can change it before the usage in other programs also.
If we want to crop the background from left, right, top or bottom, or change the color of the background or any other editing, we have been given some option in the Excel too.
After the picture has been selected for the HEADER [ which we want to insert as a background ] , Click in the Central Header Space and click on the FORMAT PICTURE BUTTON adjacent to the PICTURE OPTION under the DESIGN TAB [ Design tab appears when we click the Header or Footer Space ]. The location is shown in the picture below.
Second Tab is PICTURE. Let us have a look at the options available.
CROP FROM : Cropping is trimming the picture from any side.
We can trim the picture from LEFT, TOP, RIGHT or BOTTOM.
COLOR: We can choose the color of the background from the drop down list. Grayscale is the gray picture without color. Black and White [ Only blacks and whites ]
BRIGHTNESS and CONTRAST can also be changed as per choice.
For our example, we chose the Color as WASHOUT.
After clicking OK click anywhere on the sheet and check the background if it is as per requirement or not. If not, again format the picture.
We need features to add the background to the sheet and to be able to print this background.
We can do that with the use of SHAPES with the following steps.
After setting the transparency, we need to resize and relocate the picture so that it covers the data and looks like a background.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE