Printing hidden comments

T

Tammy

I have created a spreadsheet that cells will be marked with an X in order to
track a persons particiapation in different activities. I would like to link
all of these cells to the header cell for that column which will have a
comment attached. The purpose is so that if the cell is marked I would like
that to tell Excel to type the comment instead of the X. Is this possible.
 
D

Debra Dalgleish

You could have another set of columns that link to the first set, and
show those for printing. For example, if your marked columns are D:F,
enter the following formula in cell G2:

=IF(E2="X",E$1,"")

Copy the formula across to column I
Copy down to the last row of data

Hide columns D:F when printing
 
Top