I'd like to make some notes/mark some cells privately on a shared Google Spreadsheet in Google Drive. Is this possible?
Google Sheets – How to Make a Private Edit on a Shared Spreadsheet
google sheets
Related Topic
- Google Sheets – How to Run onEdit Script for All Users
- Google-sheets – Notes In Published Google Spreadsheets
- Google-sheets – How to restrict the number of entries for a particular column in shared spreadsheet using Google Drive
- Google-sheets – How to make one cell correspond with another for google spreadsheet
- Google-sheets – How to make a hyperlink from Google Spreadsheet cell to an Excel file
- Google-sheets – Allow others to make google spreadsheet copies that retain the view/edit permissions of its parent spreadsheet
Best Answer
I figured out a work-a-round and this is how to do it:
Shared file with edit rights
Now you're able to make notes without anybody seeing them. If you want to see them, select the cell to see the content of that cell. It won't appear in the cell itself, but to the right of the Fx symbol at the top of your screen:
Other users can't edit the sheet, thus can't control the font color.
This solution only works, if you set the sheet color to be white !!