Have you ever found yourself with a set of Google Sheets data that you can't modify because the file was shared in 'view only' mode? While it might seem frustrating, it's still possible to create a copy and edit it, allowing you to make changes as needed. Let's explore how to do this in a straightforward, step-by-step guide.
Before we dive into the process, it's important to understand that any changes you make won't affect the original 'view only' file. Instead, we'll create a duplicate that you can edit at your leisure. Now, let's get started.
Creating a Copy of the 'View Only' Google Sheets
Our first step is to make a copy of the 'view only' Google Sheets document. This way, you can make changes without affecting the original file.
1. Open the 'view only' Google Sheets file. In the top menu, click on 'File' and then 'Make a copy'.
Naming the New Spreadsheet
Now that you've initiated the creation of a new copy, it's time to give it a name. Google Sheets will automatically suggest a name based on the original file, but you can change it to something more descriptive.
1. In the 'Name' field, type your desired name for the new spreadsheet. This could be something like, "Editing permitted - [Original File Name]".
Choosing Where to Store the New Spreadsheet
Next, decide where you want to store your new spreadsheet. You can choose to keep it in your personal Google Drive or move it to a different location, like a shared folder for better collaboration.
1. Use the 'Owned by' dropdown menu to decide who should be the owner of this new file. You can also change the location by clicking on the 'Add to Drive' dropdown and selecting a different folder.
Editing the Copied Google Sheets
Now that we've created a copy and named it, we're ready to start making changes. But first, let's ensure that the new file is truly editable.
1. With your new spreadsheet open, click on 'File' in the top menu, then 'Share...'. This will open a sidebar beneath the menu.
Giving Yourself Edit Access
Ensure that you have full editing rights to the new file by changing your access level to 'Editor'. This way, you won't encounter any limitations when making changes.
1. In the 'Share with people and groups' section, find your email address and click on the dropdown menu next to it. Click on 'Editor'.
Limiting Access to Others (If Necessary)
If you've shared the copied spreadsheet with others, you can adjust their access level according to your needs. This is especially useful if you want to maintain full control over the editing while allowing others to view or comment.
1. Use the dropdown menu next to each shared user or group to adjust their access level. You can choose from 'Viewer' (can view the file) or 'Editor' (can edit the file).
Congratulations! You've successfully created a copy of a 'view only' Google Sheets file and given yourself full editing rights. From here, you can make changes, add new data, manipulate formulas, and more. Once you're satisfied with the changes, you can even share this edited version with others.
Remember, whenever you're working with copies of other people's files, it's crucial to respect their original content. Always ensure that your changes are justified, and never share others' work as your own without proper credit. Happy editing!