2

I want to add a note to a column, to tell others the format of the column. I think it is a good idea to add a review comment to the column header, but this doesn't work with frozen first row: when I scroll down, the comment moves up with the sheet.

enter image description here

enter image description here

2

After some investigation, now I'm not using review comment for column notes. From this post, we can add "Input Message" of Data Validation property to all the cells in that column.

enter image description here

enter image description here

Caveat

"Input Message" doesn't allow one longer than 255 characters.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.