Excel Excel - Hide Column or Change Font color Only for printing

[SuperBob]

Hi all,

Desperately need help on this....you'd think other people would have the same problem and it'd be easy to find, but all you get is hide and unhide column. This is too slow for me.

For an Invoicing system i need to hide prices that the salesman can look at on screen, but not be shown when printed. If hiding and unhiding columns or changing fonts whenever an order is made, i'm sure mistakes will happen.

So all i need is something that will hide or change the colour of certain cells or a column/s when the print button is clicked...simple.... ;¬)

Any help much appreciated.

 

[muckshifter]

Simply "define the printable area" ...

 

[oceansprince]

Hi there,
I can explain that but I need 3 pages to at least. But with this link am sure you would get all what you need to know : http://www.exceltip.com/category.html

I wish you good luck ..
Ocean