Step 2: Click the Page Layout tab at the top of the window. Step 1: Open the spreadsheet in Excel 2010. But if you know that your printer is a color printer and you have previously printed color documents with it, then you can follow the steps below to turn off the black and white setting for a spreadsheet in Excel 2010. Some printers, especially laser printers, are not able to print color at all. This tutorial is going to assume that you are not printing to a black and white printer. Why is My Excel Spreadsheet Printing in Black and White? The tutorial below will show you how to find the black and white printing option within that Excel file and show you how to turn it off. If you have received an Excel file that is printing in black and white, but you need it to print in color, then there is a setting that you need to change on that Excel file. This can make it difficult to remove certain settings. People have individual preferences for how they format their documents, and some people will make adjustments to menus or settings that you may not have used before. Receiving an Excel file from another person is often a frustrating proposition, especially if you need to print or edit the file.
