Are you tired of copying and pasting phone numbers to make calls from Google Docs and Sheets? Making phone numbers clickable can save you time and streamline your workflow.
In this article, we'll explore how to create clickable phone numbers in Google Docs and how to make numbers in Google Sheets click to call. With just a few simple steps, you’ll enhance your productivity and make calling easier than ever!
Table of Content
How to Enter Phone Numbers in Google Sheets
Entering phone numbers in Google Spreadsheets can be a bit tricky due to the following reasons:
Phone numbers typically contain digits preceded by a plus (+) symbol. However, an issue arises when you include the plus sign in a cell, as the spreadsheet interprets it as a math formula and tries to calculate the value.
There are two simple solutions:
Method 1: Surround the phone number with double quotes (") and precede it with an equal sign (=).
For Example: ="+1234456789"
Method 2: Add a single quote (') before the phone number. This instructs Google Sheets to treat the cell's contents as text, maintaining the phone number formatting.
For Example: '+123456789
How to Make Phone Numbers Callable in Google Sheets
You can make phone numbers on your website "clickable," just as when you click an email link to access your program. When someone clicks a number, their phone launches the calling app with the number entered immediately! Eliminate all pasting and copying!
Issue with HYPERLINK Formula: Understand that using the HYPERLINK formula with the tel protocol is not supported in Google Sheets.
Step 1: Open Google Sheet
Step 2: Select a blank sheet to edit the text
Select a blank document by visiting the Google Sheets page.
Step 3: Enter the Phone Number
Select an empty cell to enter the phone number and type the contact number in text format.
Step 4: Use call.ctrlq.org
Append the phone number with the call.ctrlq.org domain name. This action automatically converts the phone number into a clickable link.
Add https://www.labnol.org/internet/google-sheets-phone-numbers/29228 before any phone number in the Google Sheet to turn it into a callable phone link.
Step 5: Save Your Changes
Save your file once you've added the anchor tags with the phone number and tel: protocol.
Step 6: Test the Phone Number Link
Open your web page in a web browser and test the phone number link by clicking on it. It should prompt your device to call the specified phone number.
To Open Google Sheet Link with all callable Phone Number Click Here
How to Make Phone Numbers Callable in Google Docs
Making phone numbers clickable in Google Docs is equally simple. Here’s how:
Method 1: Using website's URL
Step 1: Open Google on your default web browser
Open your preferred web browser and then go to Google.
Step 2: Open Docs from the Google Workspace applications
After opening Google, you will see the nine dots tool on the right side. Click on it, and after scrolling down, you will see Google Docs in the workspace bar; click on it.
Step 3: Open the "Blank Document"
Click "Blank document" from the Docs home page. Then, give the file a suitable name.
Step 4: Enter your phone number
To begin, enter your phone number into your Google Doc file.
Step 5: Make the number bold
After inputting the number, click the "Bold" option on the menu bar.
Step 6: Link the phone number
Now that the number is highlighted search your Google Slide or Doc for the "Insert" menu. After selecting "Link" from the drop-down menu, click "Insert."
Step 7: Include the URL of the website
In the link dialog box, enter the unique website previously used instead of the standard website address: [invalid URL deleted].
Step 8: Re-enter your phone number
Repeatedly put your phone number after the website address. Thus, it ought to seem something like this: [Invalid URL deleted](555) 555-555-5555
Step 9: Check "OK" to finish the process
In the link dialog box, click the "OK" button. Your phone number has now been converted to a clickable link.
Conclusion
Finally, stop pasting phone numbers from your spreadsheets into other documents! In Google Sheets, you can now make them clickable immediately. It is helpful for jobs like cold phoning and client follow-up. Type in a unique website URL before your phone number; when you click it, the dialer on your phone will open with the number dialed. With this easy-to-use tip, you are phoning from Google Sheets.
