Is it possible to have a stationary text box whilst scrolling therows ?

[JohnC]

Lets say a have a few columns of data . To the left of this data is a
text box with some information written in it
When you scroll or the filter the data the text box moves with the
rows and can disappear out of view -is it possible to have a text box
that always remainds in view ? a floating text box ?
I think the answer is probably no - but I an amazed and some of the
ingenuity I have seen on the site

 

[macropod]

Hi John,

You can, of course, freeze the columns to the left and/or rows above the area you want to scroll. Excel gives you two options:
.. splitting the worksheet, so that the columns to the left and/or rows above the area you want to scroll are locked; and
.. freezing the panes, so that the columns to the left and/or rows above the area you want to scroll can themselves be scrolled.

 

[Max]

Maybe applying* a simple DV input msg would suffice?
It'll float next to the cell(s) as you scroll down
*Select the range, click Data > Validation > Input message tab ...

 

[JohnC]

Maybe applying* a simple DV input msg would suffice?
It'll float next to the cell(s) as you scroll down
*Select the range, click Data > Validation > Input message tab ...
--
Max





- Show quoted text -

Great!! the Date validation box did the trick

 

[Max]

Glad to hear. Celebrate it, ring the stars in google