MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding the contents of cells in printed hard copy

Posted by Keith on July 19, 2001 8:22 AM

I would like to use cell A6 to instruct user to input
certain data into cell E6 but need to hide the two
cells when the form is printed out. The data in cell E6
(ref. 0020, 0030, 0040 etc) will be converted to
generate a bar code font of the number in another cell.
This document will be printed out and used as a hard
copy form.
Any help would be greatly appriciated.
Thank you in advance.

Posted by Barrie Davidson on July 19, 2001 8:27 AM

Why not try changing the font color to white?


Posted by Roger on July 20, 2001 7:27 AM

Have you considered setting the two cells up so that they are outside the printable range in Page break view?