Hide the contents filled by each anonymous user on Excel Online

excel-online

In order to fill a spreadsheet, I need ask to 50 people to fill it using Excel Online.

Each person must fill a column in the spreadsheet. After that, when he quits the document, is there any possibility to hide what he filled to any other user (except me)?

I would also accept a Google Spreadsheets answer if this turns out to be impossible in Excel Online.

Best Answer

You should create an Excel survey so that nobody knows who else is filling out the form and they can't edit anyone else's responses.

  1. Go to OneDrive
  2. Select New > Excel survey select from the menu
  3. You will then go through a wizard asking you to create questions.
    If you want to make people answer all of them then mark each question as Required. make them all required to make them all required
  4. Add as many questions necessary
  5. Click Share survey

  6. Copy the survey link that is generated

  7. Share the link to how every many people you want to answer the questions go answer it if you wish

They will not need an account and can answer the questions anonymously.

But they are able to answer the survey again by reloading the page, so you may end up with people filling out the form more than once.

The spreadsheet will appear with the rest of those under your account.

If you ever want to edit the questions you can by:

Insert > Survey > Edit Survey

Related Topic