How to print an Excel Spreadsheet as Grayscale?

microsoft-excel printing

300

Follow these steps:

Select your Printer and then click on Printer Properties. (Right now, you can see the preview shows our sheet in color).
In Paper/Quality Tab, change the Color Setting to Black & White.
As you can see, the preview turns to Grayscale and the sheet would print out in Gray background and black font.

300

Related videos on Youtube

Author by

Aruna Srikanth

Updated on September 18, 2022

Comments

Aruna Srikanth almost 2 years

I am trying to implement OAuth 2.0 authorization code Grant between Angular (Front-End) and Spring Boot (at Back-End) using Azure AD. I am unable to get any success. I have looked into the documentations available in Azure Doc. There are no samples with Angular in Front End and Spring Boot in Back End. Any suggestions would help.
- Dave almost 11 years
  
  What happens if you print using grey scale?
- Admin almost 11 years
  
  you could have a macro that would toggle the fill before and after printing. Is this something you would consider a solution?
- user248913 almost 11 years
  
  I want the document to always show the green shade and blue font. I want the print version to always show the grey fill and the black font. I would consider anything that would allow me to do this.
- James Jenkins almost 11 years
  
  Have you tried conditional formatting?
- user248913 almost 11 years
  
  I have. The problem with conditional formatting is the cells will change from the green color to the grey color and stay that way after text is inserted. I want the input cells to always be green and just grey when they are printed.
- Carl Zhao almost 4 years
  
  please see: ordina-jworks.github.io/security/2020/08/18/…
- Aruna Srikanth almost 4 years
  
  Thanks a lot Carl for the help. You are a life saver :-)
- Carl Zhao almost 4 years
  
  I'm so happy for you, I will post it as an answer, hoping to help more people.
- Carl Zhao almost 4 years
  
  If my answer is helpful for you, you can accept it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). See meta.stackexchange.com/questions/5234/… This can be beneficial to other community members. Thank you.
Admin almost 9 years

There is no Printer properties option under Print in excel 2007. You need to say what to do in this circumstance.

Recents

Why Is PNG file with Drop Shadow in Flutter Web App Grainy?

How to troubleshoot crashes detected by Google Play Store for Flutter app

Cupertino DateTime picker interfering with scroll behaviour

Why does awk -F work for most letters, but not for the letter "t"?

Flutter change focus color and icon color but not works

How to print and connect to printer using flutter desktop via usb?

Critical issues have been reported with the following SDK versions: com.google.android.gms:play-services-safetynet:17.0.0

Flutter Dart - get localized country name from country code

navigatorState is null when using pushNamed Navigation onGenerateRoutes of GetMaterialPage

Android Sdk manager not found- Flutter doctor error

Flutter Laravel Push Notification without using any third party like(firebase,onesignal..etc)

How to change the color of ElevatedButton when entering text in TextField

Related

Remove space in Excel sheet in print preview

Double Sided Flash Cards from Excel Document

Print Range value inside MsgBox without loop in VBA

How to print two different sheets with different scale options using Excel 2007 and Excel 2010?

Print on both sides (duplex printing) by default in Excel 2010

Print multiple sheets with different orientations

Print preview doesn't work properly in Excel 2010

How we can add background color in EXCEL for printing?

Excel printed pages are different between two machines

Print two arbitrary excel worksheets as one page, double-sided