| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not print certain cells
Rather than a macro that makes borders, shading and font white of all but
certain cells at the moment of printing and then switch them back as they were before, is there a way to establish only certain cells to be printed and the rest of the cells to be ignored? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not print certain cells
Nope what you see is what you get when you print. If you are priting in Black
and White you can play with the colours of the font and the backgrounds. It's possible to come up with combinations that don't print in a way that is illegible. other than the the easiest thing to do is to come up with a seperate report which is linked to the original report but which omits the data you do not want printed... -- HTH... Jim Thomlinson "Ed" wrote: Rather than a macro that makes borders, shading and font white of all but certain cells at the moment of printing and then switch them back as they were before, is there a way to establish only certain cells to be printed and the rest of the cells to be ignored? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not print certain cells
all right yeah I see... thanks for your reply!
"Jim Thomlinson" wrote: Nope what you see is what you get when you print. If you are priting in Black and White you can play with the colours of the font and the backgrounds. It's possible to come up with combinations that don't print in a way that is illegible. other than the the easiest thing to do is to come up with a seperate report which is linked to the original report but which omits the data you do not want printed... -- HTH... Jim Thomlinson "Ed" wrote: Rather than a macro that makes borders, shading and font white of all but certain cells at the moment of printing and then switch them back as they were before, is there a way to establish only certain cells to be printed and the rest of the cells to be ignored? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
| Patterns in cells won't print | Excel Discussion (Misc queries) | |||
| group cells so they always print together | Excel Discussion (Misc queries) | |||
| how to do i use a function if cells contain grades A B C f print. | Excel Worksheet Functions | |||
| How can I print current row in same place on paper but not print surrounding cells??? | New Users to Excel | |||
Linear Mode
