Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialdjdinosauripod
356 PointsGo to row option/hotkey?
I was wondering if Google Sheets has a "Go to row 37" option / hotkey?Something similar to using find (Ctrl-f or Cmd-f) to find text.
1 Answer
Steven Parker
231,198 PointsI don't think that there is a "jump to row" feature.
But if you had an extra column with the row numbers, you can search for the row number with Ctrl-F.
If you are looking for just certain rows, you could define named ranges and use the range list as a jump table.
You could also write a script that would show an input box to ask for a row number and then activate a cell on that row.
djdinosauripod
356 Pointsdjdinosauripod
356 PointsThanks, Steven Parker. I'll check your suggestions out. The reason I thought of this was from one of the earlier quiz questions for the course and wanted to jump to see what was in row 37 instead of having to scroll through the large list.
Steven Parker
231,198 PointsSteven Parker
231,198 PointsI agree that it would be handy. Perhaps in a future update?