Turning on User Indication will show the collaborator's current position inside the spreadsheet with a user-specific color and name.
Go to ...
Tap Collaborators.
Turn on the User Indication toggle switch.