If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
prevent certain cells from printing
Id there a way to prevent the contents of certain cells from printing
|
#2
|
|||
|
|||
prevent certain cells from printing
hi
there is no built in function for this but you can.... hide rows hide columns change font color to match background color(white?) to hide areas, insert a label or text box to cover the area. there may be other way, this is just what i could think of off the top of my head. be creative. regards FSt1 "Wally" wrote: Id there a way to prevent the contents of certain cells from printing |
#3
|
|||
|
|||
prevent certain cells from printing
If there is no common characteristic such as errors in these cells,... then
there is no great solution. You would need to hide the content of the cell while printing: Format them to the custom format ;;; After printing reformat back to the default. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Wally" wrote: Id there a way to prevent the contents of certain cells from printing |
Thread Tools | |
Display Modes | |
|
|