Skip to main content
5 of 5
Undid someone else's edits to title that made it less clear
Ellen Spertus
  • 562
  • 2
  • 5
  • 20

How can I share individual columns of an online spreadsheet?

I sometimes use a spreadsheet when grading student assignments, where the leftmost columns describe the different parts of the assignments and possible points, and there is a column for each student. I'd like to make it so students can see just the columns of the spreadsheet that pertain to them (i.e., the leftmost ones and their personal column). Google spreadsheets doesn't let me do this (without making individual copies of columns into a new spreadsheet for each student). Is there a way to just share the information I want?

I saw the question Spreadsheets: Is there any cloud-based spreadsheet that can give user-based access to edit a column?, but none of the answers seem suitable, since I am interested in viewing, not editing.

Ellen Spertus
  • 562
  • 2
  • 5
  • 20