I am trying to create a Google Sheet that lists all payments made for tuition by family. I would like to use only one tab (not create a tab for each family) as I have about 120 families to keep track of.

Any thoughts of the best way to do this without having to scroll forever to get to the specific family I need to look at? Currently I have the families listed in alphabetical order in multiples of 4 going down and then the next set of 4, etc. This is easier when it comes to printing certain sections of the sheet for cross reference (i.e. not having to scroll down forever to find a name).

Date     Family
8/6/20    $150 cc = app fee
8/17/20   $550 ck #2635 = reg, corp
9/10/20   $650 ck #3016 = Aug tuit
10/12/20  $650 ck #4361 = Oct tuit
11/10/20  $650 ck #3027 = Nov tuit
12/16/20  $650 ck #2143 = Dec tuit
1/20/21   $650 ck #2738 = Jan tuit
2/26/21   $650 ck #4622 = Feb tuit

I know how to use the F5 shortcut to get to a specific cell but how do you get to a specific cell by typing in the name of the family? That would help with the whole scrolling issue.

Or if anyone has a better idea of how to record these payments I'd love your help.


1 Answer 1


Use the Find feature. Press Control + F and type a family name to jump to a row that contains that family name.

  • doubleunary.....you are my new favorite person!!!!! thank you so so much.
    – Tara Cash
    Jun 16, 2021 at 22:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.