Hi, i've been doing some research on the internet to check if this can be done with another feature different from freeze panes.
What i want to achieve is to show the table headers row only when user scrolls down enough for it to dissappear. Freeze panes would be useful if there was no data previous to the table headers, but proofs to be useless otherwise, cause if you still want to keep this info visible you must sacrifice most of the screen and let only a small area for scrolling down.
I want the worksheet to keep its normal appearance and only when i scroll down enough keep showing the top row with the headers.
I know this is possible with tables in the latest versions of excel, although it only shows the headers in a single line (without the wrap text feature), so if the header is "longer" than the width of the column, the string is cut to its width (and thus, not showing the entire header string).
Is there a way to achieve this? Let me know if you need further explanations, cause i am aware that its difficult to picture the idea just by reading its description (even more if the one giving the explanation is not a native english speaker, as myself).
Thanks in advance!
Regards,
Alberto P.