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 trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Sorting & Filtering

Posted by djdinosauripod
djdinosauripod
356 Points

Go 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
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

I 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
djdinosauripod
356 Points

Thanks, 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
Steven Parker
231,248 Points
Steven Parker
Steven Parker
231,248 Points

I agree that it would be handy. Perhaps in a future update?