Floating vs. fixed textbox relative underlying cell(s)

Stefan

New Member
Joined
Oct 27, 2002
Messages
1
I am trying to have a textbox positioned over e.g. "B11:F20" regardless of
resizing the columns involved.

I have see a solution to this problem some time ago but can not find it now
when I need it.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

DBA

Board Regular
Joined
May 28, 2002
Messages
100
Hi Stefan,

If you are simply inserting an AutoShape across the cells and adding text to it - Right Click on the "Text Box" and Select Format Auto Shape. (Be careful to select the outline of the shape and not the text within the shape or you will not have all the options).

Select the Properties Tab and Choose the "Move and Size with Cells" option.

The box should now stay above the selected cells no matter how they are sized. The box must completely cover a the appropriate cells for this to work. If there is a smidgin of the cell showing underneath, those columns or rows showing can still be changed in size without the text box changing in size.

Regards,

DBA
 

Forum statistics

Threads
1,144,290
Messages
5,723,518
Members
422,502
Latest member
barakgahtan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top