Although you can easily share a workbook in Google Sheets, you might want to direct someone to a specific part of a sheet. It’s easy to get a link to an exact cell, range, column or row to share or save.
Entering a URL to a specific section of a sheet can be very useful. You can let an employee know they need to update something, point out an error in the data to a colleague, or just save the link as a reference for yourself.
- To select a single cell, simply click on it.
- To select a range of cells, click on the first cell and drag your cursor through the remaining cells.
- To select a column or row, click the column or row header.
Once the cells are selected, they will be highlighted.
Right-click and move your cursor over Show more cell actions. Choose “Get link to this cell” or “Get link to this range” from the context menu.
You will see a brief message appear at the bottom of the window indicating that the link is copied to your clipboard.
You can then paste the link where you need it; in an email, Slack or Teams message, or another app.
Show link structure
When you paste the link, you will see the selected cell reference(s) at the end of the URL. This allows you to modify the cell, range, column or row directly in the link if needed.
Here are some examples:
Link to cell A1:
Link to column A:
Link to line 4:
Link to cell range A1 to A4:
As mentioned, getting a hyperlink to a particular cell or range can be useful for pointing out something to another person. One thing to keep in mind, however, is that you will need to share the workbook with that person so they can see the part of the sheet with your link.
RELATED: How to share documents on Google Docs, Sheets and Slides
An alternative to sharing the sheet in advance is to grant the person access when they request it. If they try to open a Google spreadsheet that hasn’t been shared with them, they’ll see an access denied message with the option to request access.
Once you grant access to the other person, they will be able to see the cell(s) you linked as well as the rest of the sheet depending on your sharing settings.
Collaborate? Let someone know they need to complete, revise, or correct the specific data you’re referring to by getting a link to an exact cell or range in Google Sheets.