Excel print black background

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. It only takes a minute to sign up.

I'm printing documents and images to a Samsung ML It used to work fine, but now it prints white instead of black, black instead of white. Text documents come out white text on solid black background. Of course, it used to work fine.

Before declaring the printer itself guilty, is it possible that something in my Linux setup, the kernel or printer driver or some hidden setting somewhere is causing this trouble? Since this problem appeared about a month ago, I've updated everything with the package manager, rebooted a couple times, and the problem persists.

Can't blame it on a cosmic ray! I had something like this happen a while back and we eventually tracked it down to some Postscript code which told the printer to print in negative, but was not revoked, and was persistent through reboot. If others have same issue, what helped solved my problem with Mac to Canon printer over wifi was:.

Sign up to join this community. The best answers are voted up and rise to the top. Home Questions Tags Users Unanswered. Why is the printer reversing black and white? Ask Question. Asked 9 years, 4 months ago. Active 3 years, 6 months ago. Viewed 28k times. DarenW DarenW 2, 4 4 gold badges 15 15 silver badges 20 20 bronze badges.

excel print black background

How did you add the printer? What's the driver name? Is that driver recommended system-config-printer displays a list of drivers, and notes what's recommended? I have a Knoppix CD somewhere. Now, months later, I don't recall any of the details. The package manager tells me cups-usblp 1.

This is Arch Linux, if I didn't mention already. Active Oldest Votes. Rest to defaults fixed it, but it took us a while going back through the logs to figure it out. Rory Alsop Rory Alsop 2, 13 13 silver badges 25 25 bronze badges. Brent Brent 1. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.Microsoft Excel has a number of different ways in which you can customize how a spreadsheet will print.

Since spreadsheets are prone to printing poorly, and due to the frequency with which they often need to be printing, properly configuring the print settings for your Excel file can be difficult.

One option that you can use, especially if you have a very colorful document, is to print in black and white. This can make many documents easier to read, while also having the benefit of saving tour colored ink. So continue reading below to learn how to print in black and white in Excel Tip: You can perform common mathematical functions in Excel. Find out how to subtract in Excel with a formula. Note that following the steps below is only going to change the setting for the spreadsheet in which you are currently working.

If you create a new file or open a different one, you will need to change the settings to print in black and white for that spreadsheet as well. Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon. Step 5: Check the box to the left of Black and Whitethen click the OK button at the bottom of the window. You can then go to print your spreadsheet normally, and all of the color will be removed from the document.

If you only print in black and white, then you can ave some money by purchasing a black and white printer. This wireless Brother laser printer has excellent reviews, a low price, and it prints very quickly.

If you are having issues getting a spreadsheet to print correctly, one helpful thing to do is learn how to print all of your columns on one page. This can prevent wasted paper that prints with just one column. Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.

Store Categories Programs Reviews Devices. How to Stop Printing Color in Excel Note that following the steps below is only going to change the setting for the spreadsheet in which you are currently working. Step 1: Open your spreadsheet in Excel Step 2: Click the Page Layout tab at the top of the window.

Filed Under: Programs Tagged With: excelexcel How to Change the Password on Your iPad 2. Return to top of page.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.

Print Background Color in Microsoft Word

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.

Setting Excel background and Printing a Spread-sheet with Background

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.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.

excel print black background

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.When we insert a background with clicking Background button under Page Layout tab in Excel, the background is not printable, and you cannot view the background in print preview.

Is it possible to print a background image in Excel? Yes, there is a special method to insert a printable background image in Excel. Insert a printable background image in Excel with drawing a shape 8 steps. Insert a printable background image in Excel with Kutools for Excel 3 steps. Insert multiple images into cells and fit to the cell size with Kutools for Excel. Kutools for Excel : with more than handy Excel add-ins, free to try with no limitation in 60 days.

Download and free trial Now! The Drawing Tools is active now, please click the Shape Fill button and fill the shape with white. Click the Shape Outline button, and replace the outline color with white as well as following screenshot shown. Then right click the shape, and select the Format Shape item from the context menu. In the Format Picture dialog box in Excel or Format Picture pane in Excelplease do the following operations:.

Click Close button. Then the shape filled with pictures looks like a background image. What's more, it can be printed out when you print the active worksheet. See the following screenshot:. Note : After inserting this background picture, you will not be allowed enter any text within the picture range.

In the Insert Watermark dialog box, select Picture Watermark option, and click Select Picture button, and in the Open dialog box, please specify the image that you want to insert as printable background, see screenshot:. Then click Open button to return to the Insert Watermark dialog, and then click Apply or Okand the selected image has been inserted into the worksheet background, when you print it, the background image will be printed as well.

See screenshot:. Download and free trial Kutools for Excel Now! Sometimes, you may need to insert multiple pictures into worksheet, normally, you just can insert only one picture into the worksheet once time, this may be time-consuming if there are lots of pictures need to be inserted.Keep in touch and stay productive with Teams and Officeeven when you're working remotely.

You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how:. To use a different background color for the whole worksheet, click the Select All button. This will hide the gridlines, but you can improve worksheet readability by displaying cell borders around all cells. Under Theme Colors or Standard Colorspick the color you want. To use a custom color, click More Colorsand then in the Colors dialog box select the color you want.

You'll also find up to 10 most recently selected custom colors under Recent Colors. When you want something more than a just a solid color fill, try applying a pattern or fill effects.

Add or change the background color of cells

On the Fill tab, under Background Colorpick the color you want. To use a pattern with two colors, pick a color in the Pattern Color box, and then pick a pattern in the Pattern Style box. To use a pattern with special effects, click Fill Effectsand then pick the options you want. To remove any background colors, patterns, or fill effects from cells, just select the cells.

Here's how you can fix that:. On the Sheet tab, under Printuncheck the Black and white and Draft quality check boxes. If you don't see colors when you preview before you print, it may be that you don't have a color printer selected. On the Home tab, click Fill Colorand pick the color you want.

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. Change the color of text. Learn more. Here's how: Select the cells you want to highlight. Expand your Office skills. Get instant Excel help.

excel print black background

Was this information helpful? Yes No.By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

excel print black background

It only takes a minute to sign up. I'm printing documents and images to a Samsung ML It used to work fine, but now it prints white instead of black, black instead of white. Text documents come out white text on solid black background. Of course, it used to work fine.

Before declaring the printer itself guilty, is it possible that something in my Linux setup, the kernel or printer driver or some hidden setting somewhere is causing this trouble? Since this problem appeared about a month ago, I've updated everything with the package manager, rebooted a couple times, and the problem persists.

Can't blame it on a cosmic ray! I had something like this happen a while back and we eventually tracked it down to some Postscript code which told the printer to print in negative, but was not revoked, and was persistent through reboot.

If others have same issue, what helped solved my problem with Mac to Canon printer over wifi was:. Sign up to join this community. The best answers are voted up and rise to the top.

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

Home Questions Tags Users Unanswered. Why is the printer reversing black and white? Ask Question. Asked 9 years, 4 months ago. Active 3 years, 6 months ago. Viewed 28k times. DarenW DarenW 2, 4 4 gold badges 15 15 silver badges 19 19 bronze badges.

How did you add the printer? What's the driver name? Is that driver recommended system-config-printer displays a list of drivers, and notes what's recommended? I have a Knoppix CD somewhere. Now, months later, I don't recall any of the details. The package manager tells me cups-usblp 1. This is Arch Linux, if I didn't mention already. Active Oldest Votes. Rest to defaults fixed it, but it took us a while going back through the logs to figure it out.

Rory Alsop Rory Alsop 2, 13 13 silver badges 25 25 bronze badges. Brent Brent 1. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.


Comments

Leave a Reply

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