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

  • Thread starter Thread starter JohnC
  • Start date Start date
J

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
 
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.
 
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 ...
 
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 -
Click to expand...

Great!! the Date validation box did the trick
 
Back
Top