Tip: You can perform common mathematical functions in Excel. Find out how to subtract in Excel with a formula.

How to Stop Printing Color in Excel 2013

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 1: Open your spreadsheet in Excel 2013. Step 2: Click the Page Layout tab at the top of the window. Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section of the ribbon. Step 4: Click the Sheet tab at the top of the window. Step 5: Check the box to the left of Black and White, then 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. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.

You may opt out at any time. Read our Privacy Policy

How to Print in Black and White in Excel 2013 - 97How to Print in Black and White in Excel 2013 - 87How to Print in Black and White in Excel 2013 - 56How to Print in Black and White in Excel 2013 - 19How to Print in Black and White in Excel 2013 - 81