Show the bigger picture in small spaces: Add images in cells with Zoho Sheet

When used correctly, images and infographics can add so much value to a spreadsheet. Zoho Sheet previously had an option to insert images into your spreadsheets, but now we're taking it a little further: You can now insert images into a particular cell! 

Inserting an image into a cell

The perks of being able to do this are endless. First, you can contextually insert images on specific cells, instead of having just a bunch of images stacked over the cells on your spreadsheet. This means the image goes anywhere the cell goes. Whether a row is inserted above or a column before, or if your cells are shifted, the image moves dynamically as well. Simply put, an image in a cell is part of the data! To make it more customizable, images inserted in a cell have their own set of options that come in handy while viewing or working with these images. 

Preview, pull, or put it over the cells

With a right-click, cells with images inserted display a few extra options that make it easier to work with or view these images. 

1. You will be able to adjust how the image is displayed in the cell, and you can choose if you want the image to fit into the cell, such as stretched over or covering the cell.
   
2. Want a closer look at the inserted images? Simply select "preview" from the right-click menu.
   

In addition to these options exclusive to images in cells, you can pull an existing image in a cell over the cells or put an image currently placed over cells into a cell if needed, with ease. 

How do I insert an image in a cell?

Select the cell you want to insert the image in. Click the Insert menu, look for an option to insert images, and from the drop down, choose the insert image "in cell" option. Zoho Sheet provides you with options to insert images from your computer, your Zoho library, other cloud drives, or even URLs. 

You can also use Zoho Sheet's new =IMAGE() function to insert images into your cells. The images you insert using the function are a little more dynamic, and it simply requires you to furnish a URL for the image you want to insert. Whether inserted via a function or through the menu, these images can be a vital new addition to your spreadsheets, letting you paint a clearer picture. 

Try out this new option to insert image into cells and let us know how you like it in the comments below! Also, head over to our Twitter profile for tips, tricks and new feature updates.

• Topic Participants

• Selva Sundaram M

  

• Sticky Posts

• Slicers are now available in Zoho Sheet—filter your data interactively

  At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,

• Check out the new Checkbox in Zoho Sheet

  Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

• Format and analyze spreadsheet data with Zoho Sheet's Table

  While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,

• Introducing Data Bars: Graphically represent changes in data within the cells

  Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

• Zia in Zoho Sheet now makes suggestions on conditional formats, picklists, and checkboxes

  Zia, Zoho's popular AI assistant, has been helping users succeed across Zoho applications since inception. In Zoho Sheet, Zia helps users efficiently build reports and analyze data with recommendations about data cleaning, charts, and pivot table. Also,

• Recent Topics

• Something went wrong. One or more fields contain errors

  I am getting this error but there is no way to debug what field is causing the issue . I have over 100 fields. Everything was working fine and then i fixed some fields that should have the same field names but had a typo and i am getting this error. It

• Integrating Zoho Desk Instances from two separate organizations

  Is it possible to integrate Zoho Desk with an instance from another organization? For example, creating a ticket in one organization can cause the creation of a ticket in the second organization? Or certain tickets from one organization be viewable by

• Send Whatsapp with API including custom placeholders

  Is is possible to initiate a session on whatsapp IM channel with a template that includes params (placeholders) that are passed on the API call? This is very usefull to send a Utility message for a transactional notification including an order number

• Knowledge base bug - Error: Article couldn't be updated.

  It took me a while to figure this out, truly one of the most irritating bugs in Zoho. I hope you find this information helpful. When using the knowledge base to create articles, make sure your keywords are in lowercase and separated by commas. Otherwise,

• Is this possible with Campaigns?

  My company is currently moving CRM's from Monday to Zoho One. Currently, our marketing lead process is send out 7 sms messages over 14 days if the lead is in a certain status. If we don't get a response the lead is put into a "Closed" status. Do we buy

• How to view two portals (Zoho CRM & Zoho Books) in single login

  Hello there, I need to create a portal access for the Customers. Customer data present in two applications namely Zoho CRM & Zoho Books. My requirement is to show the two different portals(Zoho CRM Portal & Zoho books Portal) in single login. I could

• 554 5.7.1 : Recipient address rejected: user info@intimspace.de does not exist

  554 5.7.1 : Адрес получателя отклонен: пользователь info@intimspace.de не существует I can't send an email to Google at info@intimspace.de. An error comes. I entered everything correctly in DNS https://zohomail.tools/#domainDetails/intimspace.de/ALL

• Invoice status on write-off is "Paid" - how do I change this to "Written off"

  HI guys, I want to write off a couple of outstanding invoices, but when I do this, the status of the invoices shows as "Paid". Clearly this is not the case and I need to be able to see that they are written off in the customer's history. Is there a way

• Zoho Flow or Schedules

  I have a process where we text our leads 7 times over a 14 day with different content for each text. I created one flow in Zoho Flow to do this, but wondering if there is a more efficient way to accomplish this via Schedules. It goes on for 6 more times

• Updating Bounced Contacts in Campaigns to the CRM

  The article explains how to update Opt-outs from Campaigns to CRM, but not bounces. While Campaigns will automatically remove any bounced emails from future campaigns, is there a process by which a bounce will update or make a notification in the CRM

• Bandwidth, voice and poor video

  Dear Team, The webinar has made things quite easy and convenient for educators around the world. We are an art & culture-based organization where students and researchers are our major audience.  While using the Zoho webinar platform, we have observed that the audio lags and the video is of poor quality and often freezes. Some participants don't hear what is being spoken.  We also found that even a slightly slow internet connection disrupts the webinar while it should be working well even on lower

• No Hope for Zoho Meeting

  Zoho Meeting is just the poorest meeting app I've come across in a long time. The support sucks too. I called to see if there was anything that could be done on the backend and while I was on a test meeting with support the video was lagging and freezing

• Zoho books and venmo

  Hi, Is there a way to hook Venmo into zoho books? I have a Venmo business account and want to be able to sync that. I know you can do it with the paypal integration but I dont want to use paypal for the fees and that doesnt allow me use/integrate my current

• Associate Email API Internal Error

  I am trying to associate an already existing email within a function using the Related Emails API. To provide more context, I also have admin permissions and have ensured that the fields are correct and that I have admin permissions when associating the

• Global Sets for Multi-Select pick lists

  When is this feature coming to Zoho CRM? It would be very useful now we have got used to having it for the normal pick lists.

• Contacts Don't Always Populate

  I've noticed that some contacts can easily be added to an email when I type their name. Other times, a contact doesn't appear even though I KNOW it is in my contact list. It is possible the ones I loaded from a spreadsheet are not an issue and the ones

• 550 5.4.6 Unusual sending activity detected. Please try after sometime. <a href=https://www.zoho.com/mail/help/usage-policy.html target=_blank>Learn more.</a>

  Please help me with this. Sending of mails is blocked.

• External ID validation.

  I added an external ID field as below in one of my custom modules: When creating records via the API using some value (eg: 762115b2-097e-43b2-bdba-f3924a5371a6) for this field, it works without any problem. I can create and even see the records on the

• Segmenting Contacts Based on Product Purchased

  I am trying to organize our main Marketing Automation email list in a way that segments contacts based on products they have purchased (for example in this case it is 3 different products). To my knowledge, this would require the sync from Zoho CRM to

• Update a lookup field in CRM from Creator using deluge

  I have a Creator form that creates a new account. When it creates the new account in the Accounts Module, I need it to also populate the Parent Account, which is a lookup field coming from the Module Parent Accounts, field Parent Account Name. I have

• Urgent Assistance Needed with DKIM Verification

  Hi, I have been trying to verify the DKIM for the past month using your instructions as well as other resources. Unfortunately, I have not been able to resolve the issue, and it remains persistent. I need to address this problem as soon as possible so

• How do I attach tasks from one task to other tasks in the same project

  How do I attach tasks from one task to other tasks in the same project

• Not able to change colors help center

  Hi. How can I change the orange color in the help center? You can change everything besides this font color And how can I remove the part on the bottom?

• Zoho Books Invoice Salesperson: requires ID but there is no "Fetch salesperson" action

  Hi, I am trying to attach a Salesperson to a Zoho Books invoice. In Zoho Flow, the salesperson field required an ID. However, I only have the salesperson name, I need to fetch salesperson by name and then provide the ID. There is no option to fetch salesperson...

• Change format of quantity format

  Hi,  I would like to change the qunatity format from 1,00 to 1.  Is this possible?   thanks!

• Ticket Views: filter criteria -> dynamic date values in relation to the current date

  Hello all, It would be very helpful if you could build custom views in such a way that you do not have to adjust the criteria daily or at whatever interval in order to change the fixed date value as needed. For example, I would like to create a view that,

• Captchas: No support for Google reCAPTCHA or similar

  Hi all, The current captcha integrated into Creator is very basic, and often near-impossible to read. I'm building an app for a charity which includes a couple of public-facing forms, and this is a real issue for people with dyslexia and related conditions - it's effectively excluding them if you want any form of spam protection at all on your published forms (and that being said, the current captcha doesn't even seem very effective - bots can often read it more easily than humans). I've raised this

• Maintain consistency in ticket responses with shared snippets

  Hello everyone! We are excited to announce that our highly anticipated snippet sharing feature is now available to all users. As you know, snippets are pre-defined message templates, or canned messages, that help agents respond to tickets with efficiency.

• Tickets - Zoho Desk

  Hi Team, My Clients need to see their tickets created and the status of the ticket in the Zoho Support Desk itself. How can I do this? My Client doesn't have a Zoho Account. They need to access the ticket by the provided link without signing in.

• Automatically assign Contacts to Account owners

  Hi, I have a finite number of accounts set up in the CRM, and each new contact that comes in is automatically assigned to an Account according to a rule I set up. I want the Contact owner in the Contacts module to be assigned to the relevant Account owner.

• Making Copies/Duplicates of Zoho Forms (Shared)

  Question to the community: is there a way to take a 'shared form' , make a duplicate copy and save under My Forms, so that i can use that which was already created as a template to make updates to and use as a test form and be able to have full access,

• Using IMAP configuration for shared email inboxes

  Our customer service team utilizes shared email boxes to allow multiple people to view and handle incoming customer requests. For example, the customer sends an email to info@xxxx.com and multiple people can view it and handle the request. How can I configure

• Can you help us creating a customised form with payment link?

  I would like to create a customised Transport form where the user will be asked to make payment basis the drop/ pick up they select.

• Deleting or disabeling predefined ticket list views

  Is it possible to delete or disable predefined views or is this still not possible? For instance, we are not using the chat function and therefore have no use for the "Missed Chats" view. Thanks!

• Unable to load your extension. Please check your plugin-manifest or Resources.json.

  Hi Team, I am using the config module with multiple fields of different types, such as checkboxes and picklists. However, I am encountering the following issues: Error Message: When loading the extension, I get the error: "Unable to load your extension.

• Remove or hide default views

  I'm looking to only have the views pertinent to my organization.  Is there a way to show only my custom views (or separate them to a different area or something)? If not, this should be a feature as switching from Zendesk we had this option...

• No Sales Returns on SO's with Dropped Shipped items + Inventory Items

  We have encountered an issue in Zoho related to sales orders that include both dropshipped items and inventory items. Specifically, it is currently not possible to create sales returns for the company’s own inventory items from these sales orders. This

• Layout Rules / Quick create

  Hello, is there a way to create a layout rule for quick create option? Regards, Katarzyna

• Issue with Create Note Button and Popup Form in Leads Module

  Hello Zoho Community, I am trying to implement a "Create Note" button in the Leads module with the following functionality: 1. When the button is clicked, a form should pop up with fields to add notes. 2. After filling out the form and clicking Send,

• Finding draft ticket replies

  Is there a way to see all tickets which have draft replies?

• Next Page