When I type "product.name" or "product.id" into a cell, it's auto–formatted as a URL (different colour, underlined, hover shows it as an external link). But it's not a URL, it's plain text.

Similar text like "product.periodLength" isn't converted to a URL.

Based on:

  1. How to set a Google Docs Spreadsheet cell format to bare text?
  2. How can I stop Google Sheets formatting a Forms response as a date?

I've tried setting the formatting to plain text and using a leading single quote ('), but it doesn't stop the text being formatted as a URL.

4 Answers 4


I couldn't find an absolute setting to just disable this function. However, you can disable the function from continuing to create links or start creating links in a new document simply by selecting all the cells (Ctrl+A), right-click and select "Unlink" from the options menu. As soon as you do this, Google Sheets saves the change and no hyperlinks will automatically be created. Closing and re-opening does not re-enable the function either.

  • Thanks, that did the job!
    – RobG
    Commented Nov 8, 2018 at 4:28
  • Alas, this does not work in a pivot table sheet (Apr 2020). For some reason the link options are missing from context-menu and greyed-out in the Insert menu
    – JGurtz
    Commented Apr 14, 2020 at 17:50
  • 3
    This does not work in 2020. So annoying!
    – GeneCode
    Commented Aug 26, 2020 at 7:49

(Right clicking may not be ideal when you look to automate your sheet...)

Apply method setShowHyperlink(bool) to a range of cells, e.g.

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0]
var reportRange = sheet.getRange("A2:E200")

See Google documentation - Google Apps Script .


There is now a 'remove link' option -- if you type

foo.com and hit enter

google sheets will create a link to http://foo.com ; most annoying behavior.

you can select a group of cells containing a link , right click, and choose "view more cell actions", followed by "Remove Link".


It is annoying there still does not seem to be a general setting. However, immediately after entering something Sheets turns into a link, if you then press backspace a single time the conversion to link will be undone and you can continue typing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.