LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
chris100
 
Posts: n/a
Default Excel - Hide Column/s or Change Font color Only for printing


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.

please, please please and pretty please


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=386633

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
export access to excel. change access & update excel at same time fastcar Excel Discussion (Misc queries) 0 June 24th 05 09:27 PM
Moving Excel Charts into Word Documents: font sizes change Sam Charts and Charting in Excel 4 June 24th 05 09:01 PM
Excel should allow me to change text color & font within tabs. hw Excel Discussion (Misc queries) 1 February 17th 05 10:52 PM
How to change the color of all series in an excel chart in one go. Mz2 Charts and Charting in Excel 1 January 20th 05 01:07 AM


All times are GMT +1. The time now is 05:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"