See all How-To Articles In this article, you will learn how to change a read-only file in Excel and Google Sheets. Change a Read-Only File Without a PasswordTo edit a read-only file that has no password protection, once you open a file, click Edit Anyway in the yellow read-only warning. After that, you can change the file and save all changes. Change a Read-Only File That Has a PasswordIf a read-only Excel file has password protection, there are two steps to follow to be able to change it. 1. When you open the file, in the Password pop-up, (1) enter a Password and (2) click OK. 2. Then click the Edit Anyway button, as in the previous section. Set Permissions in Google SheetsGoogle Sheets uses permissions for changes instead of read-only mode. To add permissions, follow these steps: 1. In the Menu, go to Tools > Protect sheet. 2. On the right side of the window, (1) enter a description of the setting, and (2) click Set permissions. 3. In the next window, leave the default option (Show a warning when editing this range), and click Done. This means that every time a user tries to change the sheet, they’ll be asked to confirm whether changes should be made. If you select Restrict who can edit the range instead, only specified persons can change the file. Now if you try to edit any cell in the sheet, you get the warning message in the picture below and have to click OK to proceed with changes. Can I open one of my docs/spreadsheets/etc in read-only mode? I would like to view it for reference without having to worry about it being modified.
ale 51.4k40 gold badges157 silver badges301 bronze badges asked Jun 9, 2016 at 17:38
Mark HarrisonMark Harrison 1,1173 gold badges12 silver badges18 bronze badges Well, it seems Google Documents has been updated since I wrote my first answer. There's now a button that allows you to enter read-only mode: At least this button is available in some Google Accounts. Probably a feature that is being rolled out gradually. answered Jun 17, 2016 at 13:19
Vidar S. RamdalVidar S. Ramdal 16.7k11 gold badges69 silver badges81 bronze badges 3 When you have "edit" rights on the document there are no elegant solutions out of the box to switch to a "read-only" mode temporarily. After trying out several answers and solutions I have found two solutions that work with the current version (Jun 2018) of google docs (docs, sheets, ...): Solution #1 (Print Preview mode) Use the /preview endpoint, which is a read-only view.
The only problem with this view is that you cannot use any of the data tools like sorting, filtering etc., which are usually required when you are dealing with sheets/data. Solution #2 (Create a copy)
This gives you a personal copy in your drive with full permissions but you wouldn't care making edits because it's a copy visible only to you. Once you are done with it you can delete the file and reclaim space from your drive.
answered Jun 4, 2018 at 9:08
2 It's possible, by creating a shareable link for your document, and opening it in an Incognito/Private window:
You now have a read-only version of your document in the private window. answered Jun 9, 2016 at 19:00
Vidar S. RamdalVidar S. Ramdal 16.7k11 gold badges69 silver badges81 bronze badges 1 In Google sheets, I found it effective to protect the sheet. Right click the sheet tab at the bottom of the screen. Click Protect Sheet. Click the Set permissions button. Choose Show a warning when editing this range. My users have a sheet they mostly use for reference to lookup student information. On the rare occasion they need to make a change, or accidently edit something, they receive an "Are you sure..." prompt which they must acknowledge. answered Sep 19, 2019 at 14:08
Especially when a team uses a Google Docs doc mostly for reference, accidental edits will happen. They'll get tangled in the edit history with intentional edits, making them hard to tease out. Not exactly what you were asking for: In this situation, it's sensible to switch from Google Docs to Google Sites. Sites is handy for managing a private website of reference-oriented pages. You have to explicitly click to edit a Sites page, so accidental edits don't occur. That doesn't help with Google Sheets, but Sites might have a "gadget" that can display content from a Sheet. Sites has lots of gadgets and other features for handling semi-structured information like release notes. answered Jun 11, 2016 at 2:21
Jerry101Jerry101 2,3901 gold badge12 silver badges15 bronze badges 2 It is possible.
I have tried and it works.
serenesat 9,71230 gold badges30 silver badges48 bronze badges answered Jan 13, 2020 at 2:29
3 How do I protect a Google Doc from editing?Protect, hide, and edit sheets. Open a spreadsheet in Google Sheets.. Click Data. Protected sheets and ranges. ... . Click Add a sheet or range or click an existing protection to edit it.. To protect a range, click Range. ... . Click Set permissions or Change permissions.. Choose how you want to limit editing: ... . Click Save or Done.. How do I share a Google Doc without editing?Open a file in Google Docs, Sheets, or Slides. In the top right corner, click Share. Click "Get shareable link" in the top right of the "Share with others" box. To choose whether a person can view, comment, or edit the file, click the Down arrow next to "Anyone with the link."
How do I edit a Google Doc that is view only?If you can "View only"
Open the file. Click Request edit access. If you want, add a note to the owner of the file. Click Send request.
How do I lock a Google Doc?Click on 'File', and then 'Info'. There, you'll see a drop-down 'Protect Document'. Click on it and choose 'Encrypt with Password'.
|