how to get visible selection button in freeze column with data validation while horizontal sheet scrolling [closed]
- I froze the first column.
- I applied data validation based on cell range.
- Data selection button is shown right of the cell.
- When I scroll the sheet to right, the button is never appeared until I scroll back.
- How to show up the selection button while scrolling?
Closed for the following reason
the question is answered, right answer was accepted by
Alex Kemp
close date 2016-02-22 11:01:54.960049
I want to insert predefined values in freeze column while scrolling.
Can the button be moved into the cell?