If you are using an earlier version Excel or earlier , this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Changing Excel's Background Color. The standard background color in Excel is white. You may, at some time, want to change the background color to something else, such as a light grey. Unfortunately, there is no way to change the background color; it is not a configurable option in Excel.
There are a few things you can try as workarounds, however. One approach involves selecting all the cells in the worksheet and applying a fill color to the cells. If you don't want the color to print, then you simply need to select all the cells and remove the fill color.
This could be automated by using a macro to do the color removal, printing, and re-application. There are drawbacks to such an approach, however. First, the colors used to fill the cells could interfere with the successful application of conditional formatting, if the conditional formatting involves the use of fill colors. Conditional formatting applied to font specifications shouldn't be a problem. Another option is to create, in your favorite graphics program, a small rectangle that matches the color you want used for your background.
Save the small rectangle as a graphics file, using the PNG file format. Then, within Excel, follow these steps:. The graphic image is placed in the background and repeated over and over again so that it fills the entire background.
The benefit to this approach is that it doesn't affect any conditional formatting and the background image won't print. Speaking of conditional formatting, if you aren't using conditional formatting for any purpose in a worksheet, you could use it to create your background. In a blank area of your workbook, define a cell that contains the value True. Then select your worksheet that you want to have the background color and use a conditional format to define that color. The format can look at the cell you defined, and if it is True, then the color is applied.
If the cell is not True, then the color is not applied. This allows you to turn the background color on or off for printing by changing the value of a single cell. You could also define styles for use in your worksheet. Define a style that has the desired background color, and another that does not. You can then apply the colored style when editing and the non-colored style when preparing to print. ExcelTips is your source for cost-effective Microsoft Excel training.
This tip applies to Microsoft Excel , , , , , and Excel in Office You can find a version of this tip for the older menu interface of Excel here: Changing Excel's Background Color. With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. Printing a colorized Excel spreadsheet in black and white is easy, whether you do so manually or using a short VBA procedure.
Here's how. Colors are great for readability onscreen while working in Microsoft Excel. You can use them to denote input cells, formula cells, to delineate sections, and much more. All of those visual clues are helpful to the user, but not always for the person who's viewing a printed copy. All of the formats that you've applied to make using the sheet easier can interfere with readability when printing the data.
Fortunately, it's easy to print a color sheet in black and white. In this article, I'll show you how to print in black and white manually and using a VBA procedure. Disclosure: TechRepublic may earn a commission from some of the products featured on this page. TechRepublic and the author were not compensated for this independent review.
I'm using desktop Office but you can work with earlier versions. Neither way is supported by the browser edition.
You can work with any workbook or download the demonstration. The easiest way to print in black and white is to manually set the print setting. On the con side, your users must remember to set it if the setting isn't saved. We can quickly illustrate this quick solution using the Excel template shown in Figure A. I choose it because it has a lot of color formats. Now, let's walk through the process:. To see the results of checking this setting, click the Print option on the File tab Backstage area.
As you can see in Figure C , there are no background or font colors being sent to the printer, despite what you see on screen! I may try reinstalling office tomorrow just to see if it makes a difference, as well as removing all the printers and drivers and reloading them. In this case I'm pretty sure it's probably your printer setup s for that specific machine, since setting it to black and white solves the issue. I guess I get to mark myself as the best answer in this case. I relied on the word of one of my users that she logged in and tried it.
To continue this discussion, please ask a new question. Which of the following retains the information it's storing when the system power is turned off? Submit ». Get answers from your peers along with millions of IT pros who visit Spiceworks. Best Answer. View this "Best Answer" in the replies below ». Trunker Aug 20, at UTC. Hi SeeMac, I think that setting sets black and white as the default print setting for the spreadsheet, which could explain why you only saw borders when printing in black and white if your color levels are low.
On the workstation in question, do you see the cell borders when do you a "print preview"? As a sanity check, make sure the "Line Color" from the borders menu is not white!
0コメント