I
I
Igor_092020-06-30 14:43:43
Google Apps Script
Igor_09, 2020-06-30 14:43:43

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

2 answer(s)
G
Grigory Boev, 2020-06-30
@Igor_09

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.

D
Dmitrovan, 2021-08-28
@Dmitrovan

In the name field ( Ctrl + J ) type the line number separated by a colon twice, or a range.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question