how to make cell fill color to not print

[adrien]

hello everyone,

i need help. i assigned color fill on some rows / columns, but i wish to not show them on paper everytime i print them. the color fill on all cells on rows/columns are just for the purpose of clear visibility everytime i make my report or type something on it.

is that possible? i hope i made sense.

thank you all in advance for replying and your help will be truly appreciated.

 

[Cindy Ellis]

In Page Setup, on the Sheet tab, select "Black & White". The background colors will still show up when editing or viewing on screen, but won't print.
Hope that helps,
Cindy

 

[adrien]

thank you very much for your reply. it did definitely help, just the way i wanted it.

i have another question, a little related to my previous problem. instead of the color fill won't print. i need to not print, particular cells, random. lets say, one in C9 cell, one in J10 cell.. but i can still see them on my screen, or if i'm working on that sheet. and if i'm about to print it, those cells (example given) i mentioned won't print.. i hope i made sense.

is that possible?

your reply is extremely appreciated.

 

[Cindy Ellis]

I thought maybe it could be done with a somewhat patchwork print range, but that puts each selected area on a separate page...probably not what you want.
Someone else may be able to help.

The only way I know of that it could be done would be by creating a macro that would (for instance) copy the data from the cells you don't want to print to another spreadsheet, delete them from the current sheet, print the sheet, then copy them back to their original locations.

Cindy

 

[VoG]

You could use a macro to copy the sheet to a new workbook, clear the cells, print then delete the new workbook:

Sub prt()
ActiveSheet.Copy
Range("C9,J10").ClearContents
ActiveSheet.PrintOut
ActiveWorkbook.Close savechanges:=False
End Sub

 

[adrien]

if i copy the sheet to a new workbook, and cells cleared, won't it move? i mean, input from J11 will move to J10 since it was cleared?

i haven't tried it yet, but i will later, it might be the one i needed. in case it won't, what i'd like to see if i print it, it is as if blank on those cells. texts/letters on those cells won't be shown if printed. but everytime i go back to that sheet, it will still be there, readable.

i hope i made sense.

thank you for your reply, truly appreciated.

 

[VoG]

Nothing moves and your original is unchanged.