✦Template Printable Ideas Insights

Mastering Google Sheets: Edit View-Only Files

By

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.

the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages
How to Show Edit History in Google Sheets
How to Show Edit History in Google Sheets
How to change the date format in Google Sheets!
How to change the date format in Google Sheets!

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.

Weekly Planner (Google Sheets)
Weekly Planner (Google Sheets)
How to Protect Sheets and Ranges in Google Sheets
How to Protect Sheets and Ranges in Google Sheets
an image of a computer screen showing the number of files available for each file in windows
an image of a computer screen showing the number of files available for each file in windows

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.

Google Sheets For Beginners - Lock Top Row
Google Sheets For Beginners - Lock Top Row
Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
Handy Cheat Sheets – Microsoft Office | CustomGuide
Handy Cheat Sheets – Microsoft Office | CustomGuide
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Quick tutorial: How to create dropdowns in Google Sheets (the easy way!)
Google Sheets Checklists
Google Sheets Checklists
Xlookup Tutorial
Xlookup Tutorial

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.

How to filter data in Google Sheets: user-friendly tutorial
How to filter data in Google Sheets: user-friendly tutorial
How can I highlight duplicate values in Google Sheets? 🤔💡
How can I highlight duplicate values in Google Sheets? 🤔💡
How to View Two Pages Side by Side in Google Docs
How to View Two Pages Side by Side in Google Docs

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!