Sometimes pop-ups can be blocked by Google Chrome when using Google Sheets.
To allow pop-ups in Google Sheets, please following the following steps:
- Go to Settings of Chrome.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.22.20 AM-1024x645.png)
2. Search for pop-ups in the search bar. Click Site settings at the bottom.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.23.10 AM-1024x572.png)
3. Scroll down to find the “Pop-ups and redirects” and click it.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.24.06 AM-1024x440.png)
4. Click the “Add” button next to “Allowed to send pop=ups and use redirects.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.24.44 AM-1024x482.png)
5. Finally, copy and paste “https://docs.google.com” and click add.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.25.32 AM-1024x394.png)
6. Done! Now pop-ups are allowed in Google Sheets.
![](https://simplemetrics.xyz/wp-content/uploads/2024/07/Screenshot-2024-07-26-at-11.26.03 AM.png)