Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel: don't print fill color 1
- Thread starter cramz
- Start date
-
1
- #2
Just follow these steps:
File->Page Setup->Sheet Tag.
Check 'Black and white'
Say 'OK'.
This will not print Fill color cells, but all the text in your sheet will be printed as Black...So if you don't want to use text colors and print output in only Black then adopt this method.
Sharing the best from my side...
--Prashant--
File->Page Setup->Sheet Tag.
Check 'Black and white'
Say 'OK'.
This will not print Fill color cells, but all the text in your sheet will be printed as Black...So if you don't want to use text colors and print output in only Black then adopt this method.
Sharing the best from my side...
--Prashant--
- Thread starter
- #3
I probably should have specified that some of the text needs to be in color; so telling it to print in only b&w won't solve my issue.
I thought there was something that explicitly referenced the non-printing of fill or background colors. Maybe that's access or something else.
Any more ideas?
I thought there was something that explicitly referenced the non-printing of fill or background colors. Maybe that's access or something else.
Any more ideas?
Fenrirshowl
Technical User
Cramz
Simplistic answer for you:
Set up all of your print areas and everything with your spreadsheet as is.
Select all of the cells, select no fill from the background color dropdown, print, and then undo the no fill action to regain the original.
It's only a couple of mouse clicks and probably easier than designing anything more technical.
Fen
Simplistic answer for you:
Set up all of your print areas and everything with your spreadsheet as is.
Select all of the cells, select no fill from the background color dropdown, print, and then undo the no fill action to regain the original.
It's only a couple of mouse clicks and probably easier than designing anything more technical.
Fen
- Thread starter
- #5
Fen:
I had a similar idea. I like your outside the box thinking. The only problem is that I'm not going to be the one using it. It's something I'm creating for someone's biz. And I'm locking down much of the spreadsheet's functionality, including changing format.
What I was thinking was creating a VBA module that waits for a print event and then uncolors the cells. After the print is done, it would reinstate the colors. But I don't know...it's just an idea I was toying with.
I had a similar idea. I like your outside the box thinking. The only problem is that I'm not going to be the one using it. It's something I'm creating for someone's biz. And I'm locking down much of the spreadsheet's functionality, including changing format.
What I was thinking was creating a VBA module that waits for a print event and then uncolors the cells. After the print is done, it would reinstate the colors. But I don't know...it's just an idea I was toying with.
Fenrirshowl
Technical User
I don't know your VBA ability but if you are locking down the sheets (i.e. the print area will remain the same) you can record the macros to set print area, remove the fill, print, undo etc . Then you can add a "print" button to each sheet, assign the macro and lock it down. You will have an issue about sheet protection but this is easily resolved (again record the macro while you remove and reinstate it [if you don't know the code] and patch it into the first). Hopefully it will then all work out.
Fen
Fen
- Thread starter
- #7
- Status