How to Insert an Image Link in Google Sheets
You have been taught to go for the insert option, select the image, and insert the image in Google Sheets. But what if you could insert an image link in Google Sheets and not worry about it getting over your other cells. Seems cool, isn't it? Sometimes it so happens that when you insert an image over cells, it just remains there. It doesn't get resized as per the cells or get deleted on deleting the rows or cells. So, use these steps and fix your image in the cell. It's easy and amazing!
Inserting Images with Hyperlinks in Google Sheets
Insert an Image Link in Google Sheets: 6 Steps
Step-1 Open Google Sheets App: Ready to get going? Well then, open up the google sheets application on your device. You have to look for a green-colored icon having white cells over it. Easy to spot. If you cannot find it, then go to the play store, search for Google Sheets and download it.
Step-2 Tap on Any Cell: If you are just practicing, then open up any of the Google Sheets documents and tap on any cell. But if you're ready to insert an image for a purpose, be careful.
- From the list of your sheets, select the one you want to work on.
- In that, select the specific cell inside which you want an image.
Step-3 Click on the fx Icon: Don't get scared away with the name of using fx. Firstly, it sounds scary because you are unaware of the magic it can do. You just have to be patient and understand its nitty-gritty. It's all here, just goes along.
- Once you click on any cell, the function toolbar opens up at the bottom of the screen.
- Firstly, just click on that bar. Your keyboard opens up eventually and now you're ready to learn the easy-peasy function to insert an image link in Google Sheets.
Step-4 Go for Search: Yes, you read it right! You can directly search the function and it will be readymade in front of you. You just have to add the values.
- Click on the fx icon at the bottom left and the screen of insert function opens up.
- From there, click on the magnifying glass icon to activate your keyboard and search.
Step-5 Type Image: Here you simply have to type 'image' in the search bar. From the list of all the formulas, the formula to insert an image link will come as 'IMAGE.' The word image itself is in all caps. Click on it to go further.
Step-6 Just Use the Link: By clicking on IMAGE, you are redirected to the function bar where you can insert values. Confused? Don't be, read further.
- Just observe. Your screen shows you the entire function. The function toolbar writes half the function for you.
- You just have to insert the URL.
- There are other specifications too as to mode, height, and width. But at a basic and functional level, you don't need to worry about them.
- Just copy the URL of the image that you want in the selected cell and insert it between the brackets.
- Click on the blue tick mark after pasting the URL, and the image will be added.
But take care of this one thing!
While pasting in the URL, make sure that the URL is between the brackets, and even between inverted commas. So, the entire function goes like this,
- IMAGE("URL")
Make sure you follow the format correctly. Thus, the function of inserting an image link is over. Try this option instead of inserting an image in the cell option. Like this, when you want to change the image, you just have to change the URL. Otherwise, you have to delete the inserted image, select another one, and insert. This might seem tricky but is more feasible.