Windows Forum

Ask something
Discussion Locked

Excel - 'non printing' cells

0 helpful
2 replies

by dominicjoslin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I specify that some cells on a sheet are not to be printed, as in lists prepared for drop down cells (ie: data validation) that are created in a part of the sheet other than the immediately visible 'page 1'. The reason for this question is to avoid the need for the person filling in the form to have to remember to print only 'page 1', rather than the whole spread sheet.

2 replies

by sgt_shultz

otherwise, why not make a print macro that only prints the first page. then assign the macro a button on the toolbar...maybe even remove the normal 'print' icon from the toolbar to prevent 'assidents'

This discussion is closed to new replies.