Most of the time, when we are working in excel sheets, filling up the cells with different color is necessary to highlight figures and comment to emphasize the value. And upon printing the documents, we ending up wasting lots of inks for printing too much color filled cells which is uneconomical. If you are unaware of these, you might waste upto 60% of your ink yield if you won’t avoid doing that.
To avoid this, you have to reformat the cell’s fill to white or transparent and print it which is not advisable as you will alter the spreadsheet’s format. But don’t worry as I’ll show you how to do it easier in just few steps without messing around with the format.
Let’s say we have excel sheet to print similar to below sheet which is heavily filled with lots of color which will waste a lots of your inks/toner.
To print it without the fill, all you have to do is go to the “Page Layout” tab.
Click the “Page Setup” more options, page setup will popup.
Click Sheet then tick the “Black and White” Box. That’s it.
Here is the comparison of the print preview of the before and after.
See? By simple ticking simple option, you can save a lot of inks/toner and no need for you to modify the format of your excel sheet.
Wow! This blog looks just like my old one!
It’s on a completely different subject but
it has pretty much the same layout and design. Wonderful
choice of colors!
Great website. Plenty of helpful info here. I am sending it to several buddies ans also sharing in delicious.
And obviously, thank you in your effort!
I like the helpful information you provide in your articles.
I will bookmark your weblog and check again here regularly.
I’m quite sure I’ll learn a lot of new stuff right here!
Good luck for the next!
Great article, totally what I wanted to find.
Excellent article. I am experiencing some of these issues as well..
If you are going for finest contents like me, simply go to see this
site everyday for the reason that it presents quality contents, thanks
Thanks very interesting blog!
I couldn’t refrain from commenting. Very well written!
Highly descriptive article, I loved that bit. Will there be a part 2?
Hurrah! In the end I got a blog from where I be able to truly get valuable facts regarding my study and knowledge.
I am in fact grateful to the owner of this site who has shared this great article at here.
Nice post. I used to be checking continuously this weblog and I’m impressed!
Extremely useful information specifically the remaining phase :
) I care for such information a lot. I was seeking this particular information for a very lengthy time.
Thank you and good luck.
Hello, all is going fine here and ofcourse every one
is sharing information, that’s actually good, keep up writing.
I always emailed this webpage post page to all my friends, because if like to
read it next my links will too.
This is really interesting, You are a very skilled blogger.
I have joined your rss feed and look forward to seeking more of your fantastic post.
Also, I’ve shared your web site in my social networks!
Pretty section of content. I just stumbled upon your blog and in accession capital to assert that I get
actually enjoyed account your blog posts.
Any way I’ll be subscribing to your augment and even I achievement
you access consistently rapidly.
Nice post. I learn something new and challenging on sites I stumbleupon everyday.
It’s always useful to read through content from other authors and practice a little something from their websites.
It’s appropriate time to make a few plans for the long run and it is time to
be happy. I have learn this post and if I may just I want to recommend you few attention-grabbing things or tips.
Perhaps you could write next articles referring to this article.
I want to learn more issues approximately it!
Hi it’s me, I am also visiting this site regularly, this web site is really good and the visitors
are truly sharing fastidious thoughts.
Quality content is the crucial to be a focus for the people to
go to see the web page, that’s what this website is providing.
Greetings! Very useful advice in this particular article!
It’s the little changes that will make the most important changes.
Many thanks for sharing!