✦Template Printable Ideas Insights

How to Print Black and White Only in Excel

By

In today's data-driven world, Excel has become an integral part of numerous professions. While color-coding can greatly enhance the readability and organization of your data, there are times when you need to print black and white only. Maybe you're running low on color ink, or perhaps you're adhering to a company policy that advocates for monochromatic printing. Regardless of the reason, printing in black and white is a straightforward process in Excel.

Before we dive into the steps, it's crucial to understand that Excel separates color printing settings into headers and body. This ensures that only the headers are colored, while the body remains in black and white. So, if you want your entire document to be in black and white, you'll need to change the settings for both headers and body.

Adjusting Print Settings for Headers

Headers in Excel usually contain formulas that calculate and display data at the top of each page. To change the color of your headers, follow these steps:

Print Sheets in Excel
Print Sheets in Excel
Printing Excel Spreadsheet: Everything You Need to Know
Printing Excel Spreadsheet: Everything You Need to Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know

1. Click on the 'Print' section in the 'Page Layout' tab. Select 'Print Area' and then choose 'Print Active Sheets'.

Removing Color from Headers

1. Click in the header section to select it.

[FREE] 141 Free Excel Templates and Spreadsheets
[FREE] 141 Free Excel Templates and Spreadsheets
a notebook with microsoft excel written on it
a notebook with microsoft excel written on it
how to convert excel to ppp? with the text below it and an arrow pointing up
how to convert excel to ppp? with the text below it and an arrow pointing up

2. Right-click and select 'Format Cells' from the dropdown menu.

3. In the side panel, under the 'Number' tab, click on the '' button next to 'Fill'.

4. Choose 'No Fill' to remove the color from the headers.

an excel spreadsheet in the office window
an excel spreadsheet in the office window
Day 2 – Introduction to Excel Excel
Day 2 – Introduction to Excel Excel
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
7 Excel Printing Tips: How to Print Your Spreadsheet Step-by-Step
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
How To Print Large Excel Sheet | One Page Print Setup (Excel Tips & Tricks)
Pay Stub | Pay Slip | Pay Statement | Excel & PDF Templates | Digital Download | Editable | 2 sheets in one page option | A4, Letter Sizes
Pay Stub | Pay Slip | Pay Statement | Excel & PDF Templates | Digital Download | Editable | 2 sheets in one page option | A4, Letter Sizes
how to print large excel sheet in one page
how to print large excel sheet in one page

Changing Font Color to Black

1. Select the entire header range by clicking and dragging the mouse.

2. Click on the 'Home' tab and locate the 'Font Color' icon. It's shaped like a paint can pouring out droplets.

3. Choose 'Black' from the color scheme to change the text color of your headers.

Scan a document into Excel with the free mobile app!
Scan a document into Excel with the free mobile app!
Copy Data From One Sheet to Another in Excel
Copy Data From One Sheet to Another in Excel
Duplicate a Sheet in One Drag in Excel
Duplicate a Sheet in One Drag in Excel

Adjusting Print Settings for the Body

Now that you've adjusted the settings for your headers, let's do the same for the body of your data.

Removing Color from the Body

1. Make sure no cells are selected. If any are, click outside the grid to deselect them.

2. Again, go to the 'Format Cells' option as explained above (File -> Options -> Advanced -> Edit Custom Formats).

3. Similar to the headers, choose 'No Fill' to remove color from the body.

Changing Font Color to Black

1. Select the entire body range by clicking and dragging the mouse.

2. Follow the same steps as before to change the font color to black.

It's worth noting that these changes will only apply to the current workbook. If you want to apply these settings across all your workbooks, you'll need to make the changes in each one.

Testing Your Changes

Before finalizing your changes, it's always a good idea to preview your document to ensure everything is as expected.

Printing a Preview in Excel

1. Press 'Ctrl + P' on your keyboard or go to the 'File' menu and select 'Print'.

2. Your document will open in the print preview mode. Here, you can see how your document will look when printed.

Adjusting Your Printer Settings

1. In the print preview window, click on the 'Printer Properties' button (usually found at the bottom of the window).

2. Here, you can further customize your print settings, such as paper size, orientation, and scale.

And there you have it! With these simple steps, you are now ready to print your Excel documents in black and white only. Keep your Excel skills sharp and happy printing!