Identify Cells

  • Thread starter Thread starter Nick Giordano
  • Start date Start date
N

Nick Giordano

Hi,

How can I place an identifier in a cell to identify members of each group,
so when the spreadsheet is printed, the reader can see what cells are
members of each group. For example, if A1 and B7 are members of group 1, I
would like to place the number 1 in the upper left corner of each cell, in
this case A1 and B7.

This would be similar to the upper right corner marking when a cell contains
a comment.

Thank you,

Nick
 
Hi,

Thanks.

Color coding will not be presented properly on printed copies. So, for the
time being, I created a column to the right of the data column, noted the
groupings in that column and sized the column title to span both columns.

Thank you for the input.

Nick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Area to include text box 10
Array formula to Identify Leading Zeros. 2
Moving comment box leader arrow head 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
How do I automatically generate a worksheet. 1
Transfer Comment to VLOOKUP Cell on Search 3
Pasting Formula Based on 2 Existing Formulas 2

Back
Top