How To Get Google Sheets Out Of View Only

Google Sheets is a powerful tool for managing and analyzing data. However, there may be times when you’re unable to edit a document because it’s stuck in “View Only” mode. If you’re facing this issue, you’re at the right place. This step-by-step guide will teach you how to get Google Sheets out of “view only” and back into editable mode.

Step 1: Ask for Permission

The most common reason why a Google Sheets document is in “View Only” mode is because you don’t have the necessary permissions to edit the document. The owner of the document likely set it to “View Only” mode.

To gain editing access, you need to request permission from the document owner. Click on the blue “View Only” button on the top right corner of the screen. A dropdown menu will appear. Click on the “Request Edit Access” option. Fill in the request form and click “Send”.

Step 2: Check If You’re Signed In

Another reason why you might be stuck in “View Only” mode is if you’re not signed into your Google account. Google Sheets requires users to be signed in to edit documents.

Check the top right corner of the screen. If you see a blue “Sign In” button, click it and sign in to your Google account.

Step 3: Make A Copy of the Document

If you’re still unable to edit the document after completing the steps above, one workaround you can try is to make a copy of the document. Note, however, that this only works if the document owner has allowed users to make a copy of the document.

Click on the “File” menu on the top left corner of the screen, then select “Make a Copy”. You will be able to edit your own copy of the document.


Getting stuck in “View Only” mode on Google Sheets can be frustrating, especially when you need to edit a document. However, by following the steps outlined in this guide, you should be able to regain editing access to your document in no time. Happy editing!