Saturday, September 25, 2021
Home Technology Software Setting Excel background and Printing a Spread-sheet with Background

Setting Excel background and Printing a Spread-sheet with Background

This post is to address an every day issue that you face when working with spread sheets (MS Excel – OpenOffice Spreadsheets etc). We normally cannot print spreadsheets with a background. I mean when you print the document it does not show the background graphic.

When confronted with this problem I googled it up. (Sorry can’t help. it’s a habit) Now Microsoft, as we all know, are charming people who love it when you have trouble using their product. They said “This issue occurs because background graphics cannot be printed in Excel.” How smart and what a useful answer. Guess what they even ask “Did this information solve your problem?” I felt like kicking that bloke who wrote this in the ‘you know which’ place.

Ok enough.. Now here is the solution.

Setting a background for your Microsoft Excel Spreadsheet

backgorund-excel

I hope the screen-shot would suffice. All you need to do is go to the main menu. Then Choose Format >> Sheet >> Background.

Browse the image file and select it.

The back ground will get tiled all over the work area. There is no overriding this I guess. So choose a proper sized graphic to fit your printable area.
Tip: Use white space around the image (photoshop or other graphic tool) to fit it wherever you want on the printable area. See this example.

Seriously I do
Seriously I do

Now if you want to print the same you would never get the background. Try and check the print preview.

So How to Print the Spreadsheet along with the Background?

Save the file as webpage. (.html or .htm)

Then open the file in your browser and print as you like. Remember to do the print set up properly. On my Firefox I do this.

print-setup

Hope that helped.

5 COMMENTS

  1. it works to print the excel file with the background image, however the resolution is so low can’t really read the information anymore. any other methods?

Comments are closed.

Most Popular

Abacus for Kids FAQs

What is Abacus? Abacus is a "counting frame" or a very old calculating device that helps us to do mathematical...

Organic Food and Its Importance for Our Health and Our Planet

Food constitutes one of the pillars of human survival, besides being a source of our energy. Over the years of evolution, food...

List of Organic Vegetables Price in Delhi from Organic Food Suppliers

After facing the pandemic and realizing the need to build strong immunity in our bodies, we today witness a strong push towards...

Top Gift Ideas To Celebrate This Christmas Day With Your Family

Christmas is celebrated every year on the 25th of December. It brings joy and cheers to our life. People celebrate Christmas to...

MY DICTIONARY PROJECT

I have started a new project called the Indic Dictionary. This will cover popular household words in India and what they are called in various languages. Eventually, I will make this an easy to use app where where people can easily find something like “hing in English” or “Tea Tree Oil in Hindi” or “carrom seeds in Urdu”.