 |
VOOZH | about |
|
VOOZH | about |
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
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
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.
Select a blank document by visiting the Google Sheets page.
Select an empty cell to enter the phone number and type the contact number in text format.
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.
Save your file once you've added the anchor tags with the phone number and tel: protocol.
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
Making phone numbers clickable in Google Docs is equally simple. Here’s how:
Open your preferred web browser and then go to Google.
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.
Click "Blank document" from the Docs home page. Then, give the file a suitable name.
To begin, enter your phone number into your Google Doc file.
After inputting the number, click the "Bold" option on the menu bar.
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."
In the link dialog box, enter the unique website previously used instead of the standard website address: [invalid URL deleted].
Repeatedly put your phone number after the website address. Thus, it ought to seem something like this: [Invalid URL deleted](555) 555-555-5555
In the link dialog box, click the "OK" button. Your phone number has now been converted to a clickable link.
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.
