View Single Post
 
Old 01-27-2010, 12:51 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

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
File Type: xls Fixed text.xls (13.5 KB, 39 views)
Reply With Quote