How To Print Excel Sheet Without Color

This page explains how to print an Excel worksheet without fill color, focusing on saving ink by printing in black and white only. Is there a way I can shade a cell, but keep that cell from being shaded when I print the sheet? For example, I want someone to enter data only in the cells I've shaded yellow, but I want the finished print to not have yellow, shaded cells. Learn how to print your Excel worksheets without any colour.

A great quick Excel tip to save on ink, colour distraction and improve printing quality. This video shows you an option to print excel cells in black and white without fill color, so you can save your ink & money today! How does it work? There are 4 simple steps to follow: 1. Is there a way I can make cells have some kind of highlight/background color that doesn't show up when the document is printed? But I'm NOT talking about printing in black and white! I mean to still print in color, but have a cell show a particular color, but when the document is printed (or saved as a pdf) that color reverts to the default value.

Example 1: To print the worksheets without fill color. Step 1 To understand the process of printing the worksheet without using the fill color. Consider the given Excel sheet below.

This excels sheet contains two columns. The first column is for color, and the second column is for fill. Before Print Print Preview Info:- 1) Remove the Green color when printing (Ctrl+P).

2) Not all cell with green color user will enter input. however, still need to remove the green when printing (ctrl+P). 3) This excel will used by basic user which they would not know about run Macro or VBA.

Sample Excel (Download): excel_Example.xlsx. Re: Print without colours In Excel 2003: Print Preview > Setup > Sheet > Black and White > OK In Excel 2010: Page Layout > Sheet Options > Sheet > Black and White > OK Sheet Options are below Gridlines and Headings Excel 2010 Alternate: Print > Page Setup > Sheet > Black and White > OK Lewis Register To Reply 03-10-2015, 03:15 PM #3 Onesock. The video offers a short tutorial on how to print worksheet without colors in Excel.

I have a spreadsheet form that I need to show color formatting when it's on the computer, but I need it to print without the color in certain cells. I only have a black and white printer, so when I print the spreadsheet, no matter how light I make it, it's too dark and you can't read the data entered.