Follow the steps below to easily remove all hyperlinks in Google Sheets.
Start by clicking and dragging over the cells that contain the hyperlinks you want to remove. If the cells are not next to each other, hold down the Ctrl key (Cmd on a Mac) while clicking each cell to select them individually.
Right-click on any of the highlighted cells to bring up the context menu. This menu provides a list of actions you can perform on the selected cells. Click "Remove Link" to delete all hyperlinks. This will instantly remove all hyperlinks from the selected cells and leave the text intact.
After removing the links, click through the previously linked cells to ensure all hyperlinks have been successfully removed. The text should remain, but it will no longer be clickable.
We hope that you now have a better understanding of how to remove all links in Google Sheets. If you enjoyed this article, you might also like our article on how to do natural log in Google Sheets or our article on how to do linear regression in Google Sheets.
