• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

TechLila

Bleeding Edge, Always

  • Home
  • About
  • Contact
  • Deals and Offers
Techlila Logo
Share
Tweet
Share
Pin
58 Shares
How to Find the Name of a Song Without Lyrics
Up Next

How to Find the Name of a Song Without Lyrics

Google Phone Numbers

TechLila Internet

How to Make Phone Numbers Callable in Google Sheets

Avatar of John Hannah John Hannah
Last updated on: December 15, 2019

Google’s foray into Office tools such as Spreadsheet and Docs made things easy and work-on-the-go. But as with Google, many of the features went pretty undiscovered.

One of these features include in Google Spreadsheet – How to Make Phone Numbers Callable in Google Sheets?

Some of you might not even venture into this line of thought, but it’s always better to be a step ahead. You never know when it will come in handy and don’t know how to proceed when such a scenario comes.

Before you proceed to Google phone numbers to be attached to Google spreadsheets, what is meant by ‘Callable’?

You must have seen ‘Contact Us’ pages on the various website which provides you an email-ID to contact. Mostly, they provide the feature which leads you directly to your email client to address them an email.

On the same lines, nowadays phone numbers are being added to pages so that you can directly call them and get to know the details. Retail stores and food outlets are following this scheme pretty religiously.

Moreover, with the penetration of mobile phones in more and more household, people now can connect with stores and other places directly from home, one of them being through directly calling them.

How are Phone Numbers Added in Web Pages?

Phone numbers can be easily added to web pages by just following the HTML protocol.

Callable Phone Numbers

By following the above scheme, you can easily add Google phone numbers.

How to Insert Google Phone Numbers in Google Sheets

Unlike web pages, it’s very tricky to add Google phone numbers to Google Sheets.

Because most of the phone numbers starting with a (+) sign (international codes), Google Sheets treats it as a math formula and in turn, tries to calculate the value. Which, returns an error.

To resolve this error, you can do this:

Make Phone Number Callable
  • Enclose it in double quotes (“) and precede it with an equal-to sign (=)
  • Or simply, precede the entire number with a single quote (‘)

How to Make Numbers Callable in Google Sheets?

Even though we successfully typed the numbers into the Sheets, the numbers displayed aren’t clickable. They are only displayed.

One solution would be using the HYPERLINK() protocol. Along with the tel protocol, theoretically, it should do the job easily.

But the HYPERLINK() protocol only supports mailto and the regular http protocols. Meaning, you can only link it to email addresses and website addresses.

The simple solution would be to direct the link to any website which would, in turn, redirect to the actual telephone number.

Suppose you have the phone number in cell ‘A1’, just follow these scheme:

=HYPERLINK(“https://techlila.com/call/”&A1; “Call”)

Hyperlink Number

The final result would come like this:

Callable Google Phone Numbers

That’s it! It’s really so easy to add.

Let us know if you have some doubts or concerns and we would help you as soon as possible.

Share
Tweet
Share
Pin
58 Shares

Disclosure: Content published on TechLila is reader-supported. We may receive a commission for purchases made through our affiliate links at no extra cost to you. Read our Disclaimer page to know more about our funding, editorial policies, and ways to support us.

Sharing is Caring

Share
Tweet
Share
Pin
58 Shares
Avatar of John Hannah

John Hannah

    John Hannah is a part-time blogger. He likes to travel a lot.

    Category

    • Internet

    Tags

    Google, Google Drive

    Reader Interactions

    What people are saying

    1. Avatar of MilindMilind

      Hi John, I really appreciate your article and way of representation. Keep working. Good luck!

      Reply
      • Avatar of Mahesh DabadeMahesh Dabade

        Thanks Milind :)

        Reply
    2. Avatar of BenjaminBenjamin

      Nice one mark
      This is another new tip to work on.

      Reply

    Add Your Comment Cancel reply

    Your email address will not be published. Required fields are marked *

    Primary Sidebar

    Popular

    How to Increase Broadband Speed on Windows

    10 Best Android Launchers of 2021

    Things to Do After Installing Windows 10 – Windows 10 Tips and Tricks

    Top 10 Search Engines You Can Use to Search the Web Privately

    55 Interesting Computer Facts That Will Blow Your Mind

    What to Look for When Buying a Laptop – A Laptop Buying Guide

    Fusion Drive Vs SSD – Things Nobody Tells you About Fusion vs SSD Storage

    Useful Tools

    • Grammarly – Free Grammar Checker
    • SEMrush – The Best SEO Tool Trusted by Experts
    • Setapp – One-stop subscription for Mac and iOS

    Trending Topics

    • Android
    • Internet
    • iPhone
    • Linux
    • Macintosh
    • Security
    • Social Media
    • Technology
    • Windows

    Worth Checking

    10 Best Sound Equalizer for Windows 10 (2022 Edition!)

    14 Best VLC Skins that are Highly Recommended and Free

    Footer Logo Footer Text Logo

    Footer

    About

    Hello and welcome to TechLila, the famous technology blog where you can find resourceful articles for mastering the basics and beyond.

    At TechLila, our main goal is to provide unique information, such as quality tips and tricks, tutorials, how-to guides on Windows, Macintosh, Linux, Android, iPhone, Security and a few miscellaneous sub-topics such as reviews.

    Links

    • About
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • Terms

    Follow

    Custom Theme Using Genesis Framework

    Cloud hosting by Cloudways

    Language

    en English
    bg Българскиzh-CN 简体中文nl Nederlandsen Englishtl Filipinofr Françaisde Deutschid Bahasa Indonesiait Italianoja 日本語pl Polskipt Portuguêsro Românăru Русскийsr Српски језикes Españolsv Svenskatr Türkçeuk Українськаvi Tiếng Việt

    © Copyright  2012–2023 TechLila. All Rights Reserved.