Answer the question
In order to leave comments, you need to log in
How to implement search by row number in Google Sheets?
There is a very large table, often you need to find a specific row (initially knowing its ordinal number). Turning the wheel or slider is extremely inconvenient. How to implement it? Or maybe there is already something similar somewhere? - Unfortunately, I couldn't find it.
Answer the question
In order to leave comments, you need to log in
Make a macro, while recording, go to line 100, for example; save, assign hotkeys (if necessary).
All that remains is to correct the code - enter a line request through inputBox(title, prompt, buttons) and make the transition not to line 100, but to line number N .
Another option is to make a sidebar with the line number entered there, if suddenly the pop-up window does not fit.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question