Hi there,
I have a proposal for a solution.
(the English menu commands are translated from Swedish and might therefore not be 100% equal to the actual text in English Excel).

Create a textbox that goes over several columns. Right click on the textbox and select "Format...". Now select Select "Properties" and then the radio button "Don't move or change size when with cells". + OK.

If you donä't have a constant text in the textbox, you can link it to a cell. Mark the textbox, click the formula field an write (example): =Sheet1!M1



Now you can hide/unhide without any change of the textbox.

See my attached example.

Let me know if this helps you!

Kind regards from snowy Sweden!
Bjorn

Attached Files

Fixed text.xls (13.5 KB, 51 views)