Skip to main content. For a Microsoft Excel 95 version of this article, see When you print a worksheet that contains a background graphic in Microsoft Excel, the graphic is not printed. The background graphic is also not displayed in print preview. This issue occurs because background graphics cannot be printed in Excel. More Information. To add a graphic to the background of an Excel worksheet, follow these steps: Open the worksheet in Excel. On the Format menu, click Sheetand then click Background.

Select the graphic that you want to appear as the sheet background, and then click OK. Last Updated: Apr 16, Was this information helpful? Yes No. Tell us what we can do to improve the article Submit. Your feedback will help us improve the support experience. Australia - English. Bosna i Hercegovina - Hrvatski. Canada - English. Crna Gora - Srpski. Danmark - Dansk. Deutschland - Deutsch. Eesti - Eesti. Hrvatska - Hrvatski.

India - English. Indonesia Bahasa - Bahasa. Ireland - English. Italia - Italiano. Malaysia - English.

Excel 2016 - Fill Colors & Backgrounds - How to Change Cell Color & Background - Apply Colour Cells

Nederland - Nederlands. New Zealand - English. Philippines - English. Polska - Polski. Schweiz - Deutsch. Singapore - English. South Africa - English.

excel print black background

Srbija - Srpski. Suomi - Suomi. Sverige - Svenska.But have you ever thought how you can use your creativity to create amazing and attractive spreadsheets? In this post, I am going to share one such technique, here we are going to learn how to add background images in your Excel worksheets. In this method we will are not going to add the image as a background but instead we will add the image on top of another object. And then we will adjust the object so that it fits in the whole printable area.

To use the method follow the below steps:. Ankit is the founder of Excel Trick. He is tech Geek who loves to sit in front of his square headed girlfriend his PC all day long. Ankit has a strong passion for learning Microsoft Excel. His only aim is to turn you guys into 'Excel Geeks'. Thank you very much. I am Excel orientated and I am interested to learn as much as possible. I am teaching my daughter 6 yrs old slowly, and she already knows how to copy, paste, move between files open with short cuts.

She is very proud and my wife marvelled. And of course I am very happy thinking in her future. This is the Secondary Sidebar Widget Area. You can add content to this area by visiting your Widgets Panel and adding new widgets to this area.

Privacy Policy Disclaimer About. Use an Image as a Background in Excel. Comments Ruben Costa says:. July 13, at pm. Learn Excel with Us! Stay Connected With Us! Join 5. Visit the Excel Trick Store.Last weekend, I was using Ancestry. So far, so good. In other words, the document previously printed in black print with a white or unshaded background. I have changed variouis settings in Word several times since, highlighted the table cells trying to reverse the highlight, each time printing a page to determine whether the page actually prints properly and even went back to Ancestry and viewed and printed a document or two to try to reverse the settings.

But so far I have found nothing that completely reverses the background from black to white. I saw something about resetting the printer defaults to factory settings, so I tried that too. But so far, it hasn't worked either.

excel print black background

I think it's easier to read black print on a white background. I need:. My best guess would be you may need to uninstall the printer software driversince windows 10 is a different operating system.

You also may try setting the printer back to it's factory defaults. If you can print internal reports from the printer, and everything looks fine, and documents from your computer look incorrect- it's more than likely the driver.

Thanks for your reply. I have already tried returning the printer to its default settings. I bought it a few years ago just before they changed the model to a different that is now wireless. If I have any more problems, I will reinstall the printer. Thanks for the suggestion-I had thought about it; but really didn't want to do it unless I had to. Didn't find what you were looking for? Ask the community. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for. Search instead for. Did you mean:. This topic has been archived. Information and links in this thread may no longer be available or relevant. If you have a question create a new topic by clicking here and select the appropriate board. All forum topics Previous Topic Next Topic. New member. Message 1 of 3. HP Recommended.

Use an Image as a Background in Excel

I need: HELP to reverse this! Thanks in advance to anyone who can help! Tags 2. Tags: Archived. Level 7. Message 2 of 3. What is the model of your printer? I am not a HP employee. I am a service tech on these forums researching topics and offering my best guess to aide in your troubleshooting.In Excel, we always format the cell data with some colors to make the important information stand out.

When you print the worksheet, the filling color behind the value or the font color of the data will be printed as well see following screenshot.

Inverted text or white text on a black background when printing - Windows 10

To consider for saving ink, sometimes, you need to print the worksheet without fill color, that is to say, to print with black and white. Is there an option to print these cells black and white only in Excel? Print worksheet without fill color in Excel. To print the worksheet with black and white, you just need to change the setting as following steps:. Then click Page Layout tab in the ribbon, and click Page Setup button at the bottom-right corner of the Page Setup section. See screenshot:.

In the Page Setup dialog, click Sheet tab, and then check Black and white option under Print section, see screenshot:. Then click Print Preview button in the Page Setup dialog to view the worksheet, and your current sheet is displayed as black and white as following screenshot:. And then you can go to print your worksheet normally, and all of the color will be removed from the file except white and black.

Related articles:. How to print multiple workbooks in Excel? How to print ranges in Excel? How to quickly print current page in Excel? How to print long column on one page in Excel? How to print title top row on every page repeatedly in Excel? Log in. Remember Me Forgot your password? Forgot your username? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.

In Microsoft Excel, you can use a picture as a sheet background for display purposes only. A sheet background is not printed, and it is not retained in an individual worksheet or in an item that you save as a Web page.

Because a sheet background is not printed, it cannot be used as a watermark. However, you can mimic a watermark that will be printed by inserting a graphic in a header or footer. Click the worksheet that you want to display with a sheet background.

Make sure that only one worksheet is selected. Select the picture that you want to use for the sheet background, and then click Insert.

To improve readability, you can hide cell gridlines and apply solid color shading to cells that contain data. To use a solid color as a sheet background, you can apply cell shading to all cells in the worksheet. Click the worksheet that is displayed with a sheet background. Delete Background is available only when a worksheet has a sheet background. Watermark functionality is not available in Microsoft Excel. However, you can mimic a watermark in one of two ways. That picture then appears behind the worksheet data, starting at the top or bottom of every page.

You can also resize or scale the picture to fill the whole page. You can also use WordArt on top of the worksheet data to indicate that the data is confidential or a draft copy.

In a drawing program, such as Paintbrush, create a picture that you want to use as a watermark. Under Headerclick either the left, center, or right header selection box. Double-click the picture.

Click in the worksheet. Before printing, make sure that the header or footer margin has sufficient space for the custom header or footer. To switch from Page Layout view to Normal view, select any cell, click the View tab, and then, in the Workbook Views group, click Normal.

On the Insert tab, in the Text group, click WordArt. Note that this only changes the size of the box that contains the WordArt. Select the text inside the WordArt, and then on the Home tab, in the Font group, select the size you want in the Font Size box.

To add transparency so that you can see more of the worksheet data underneath the WordArt, do the following:. In the Fill category, under Fillclick Solid fill. Drag the Transparency slider to the percentage of transparency that you want, or enter the percentage in the Transparency box. On the Format tab, in the Arrange group, click Rotate. On the Size tab, under Size and rotatein the Rotation box, enter the degree of rotation that you want.

You can then insert the picture that you created in the drawing program into a header and footer as described in Use a picture in a header or footer to mimic a watermark. If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and add a sheet background.

You can always ask an expert in the Excel Tech Communityget support in the Answers communityor suggest a new feature or improvement on Excel User Voice. Learn more.

The selected picture is repeated to fill the sheet. A sheet background is saved with the worksheet data when you save the workbook. In Excel, click the worksheet that you want to display with the watermark.By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Super User is a question and answer site for computer enthusiasts and power users.

It only takes a minute to sign up. Is there an easy way to apply a dark theme to my excel windows: black or gray background on all cells, light text. I would do as CharlieRB suggests and additionally set a small background image, any color, or image that works for you. You can make this a default template as well if you like. Not sure how printing will work for you, but you could set a custom view to deal with printing, if that is an issue.

You cannot print a background graphic for a Excel worksheet

He posted this image, and I am posting the link. Hopefully, it helps people as it helped me. Office now has dark mode for Mojave OS on Mac. It just came out today for the Insiders Fast track updates.

I've been looking forward to this for years. I don't prefer the insider's updates, because I don't want to test Excel for Microsoft. Also, the updates come too often, disrupting my work flow. I have managed to get my Excel, Word and Notepad to all show light gray background by default by changing the Windows Theme, which works well for me.

I have windows 10 and Office and have been struggling with this for a long time.

excel print black background

I had to create a new theme and change the Window Color to gray. Sign up to join this community. The best answers are voted up and rise to the top. Home Questions Tags Users Unanswered. Ask Question. Asked 7 years, 11 months ago. Active 4 months ago. Viewed 98k times. Der Hochstapler Jonah Jonah 1 1 gold badge 6 6 silver badges 14 14 bronze badges.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.

Learn More. Learn how to collaborate with Office Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Did this solve your problem?

Yes No. Sorry this didn't help. I have the same problem. New laptop Windows 10 prints white letters with black background. All other devices in house.

excel print black background

I tried what you suggested and it doesn't work. Any other suggestions? April 7, Keep in touch and stay productive with Teams and Officeeven when you're working remotely. Site Feedback. Tell us about your experience with our site. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question CharlesJones32 Replied on August 13, Independent Advisor. I understand that your background is black, the white letters and you want to reverse that configuration, if that is the case, apply the following steps: 1.

Thanks for marking this as the answer. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. How satisfied are you with this response? All other devices in house print correctly.

This site in other languages x.


Replies to “Excel print black background”

Leave a Reply

Your email address will not be published. Required fields are marked *