There might be an easier way of doing this but
I have an excel sheet with columns A and B frozen so they are visible when scroll right.
I have a text in row 1 merged across columns A to Z.
The document spans columns A to BZ
I would like the header text in row 1, the document title, to remain visible when scrolling to the right, i have tried putting it in a text box and selecting do not move with cells option but that doesn't seem to work either.
Is my question understandable? I can upload an excel sheet to demonstrate if wanted. Any help would be greatly appreciated.