The underlying issue seems to be that it is difficult to locate the intersection of a row that is labeled with a specific task name and a column that is labeled with a specific name.

Assuming that task names are in column A and people's names are in row 1, choose View > Freeze > 1 row and 1 column to keep those names always visible. As you move around the sheet, the row number next to the task name column gets automatically highlighted, as does the column label on top of the person's name. Use this visual cues to track where you are.

The underlying issue seems to be that in a large spreadsheet it is difficult to locate the intersection of a row that is labeled with a specific task name and a column that is labeled with a specific name.

Assuming that task names are in column A and people's names are in row 1, choose View > Freeze > 1 row and 1 column to keep those names always visible. As you move around the sheet, the row number next to the task name column gets automatically highlighted, and so does the column label on top of the person's name. Use these visual cues to track where you are.