freeze panes eats comments

marcs

Active Member
Joined
May 3, 2005
Messages
420
I've got the top row of a WS frozen because the cells are the headings for the columns.

The headings have comments describing what the columns are etc. Sometimes they are quite big comments with instructions.

When the rows beneath the top row are scrolled, any comment boxes which extend below the freeze line get chopped up. Is there any way round this.

I've tried making the comments wider and shallower but then they go off the edge of the WS. I don't want to use validation because the headings don't get selected.

All help appreciated
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
I don't know of solution, but if it makes you feel better I have the same problem.
 

marcs

Active Member
Joined
May 3, 2005
Messages
420
Of course it makes me feel better - but also worse - somehow.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,736
Messages
5,573,921
Members
412,555
Latest member
mark84
Top