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

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.

    Access your files securely from anywhere


            Zoho Developer Community




                                      Zoho Desk Resources

                                      • Desk Community Learning Series


                                      • Digest


                                      • Functions


                                      • Meetups


                                      • Kbase


                                      • Resources


                                      • Glossary


                                      • Desk Marketplace


                                      • MVP Corner


                                      • Word of the Day



                                          Zoho Marketing Automation
                                                  • Sticky Posts

                                                  • Revamped Print in Zoho Sheet—customized for paper

                                                    The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
                                                  • 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


                                                  Manage your brands on social media



                                                        Zoho TeamInbox Resources

                                                          Zoho DataPrep Resources



                                                            Zoho CRM Plus Resources

                                                              Zoho Books Resources


                                                                Zoho Subscriptions Resources

                                                                  Zoho Projects Resources


                                                                    Zoho Sprints Resources


                                                                      Qntrl Resources


                                                                        Zoho Creator Resources



                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • Animated GIF Images in Chat

                                                                                                    I know this seems to be a small feature request but in a recent Cliq update Zoho disabled autoplay for animated GIFs posted in Cliq conversations. We think this was not a good change. In our organization, animated GIFs in a chat play a role in expressing
                                                                                                  • Generate a Zoho Sign link

                                                                                                    From time to time I get a response "I never received your you e-document for electronic signature" is there a way to generate a Zoho Sign link to share.
                                                                                                  • 【Zoho CRM】翻訳機能のアップデート

                                                                                                    ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 今回は「Zoho CRM アップデート情報」の中から翻訳機能のアップデートをご紹介します。 今回のアップデートにより、翻訳機能が拡張され、さらに多くの言語に対応できるようになりました。 またこれまでは、「見込み客のデータ元」の選択リストの値や商談のステージ名といった、特定の値については画面の設定言語を変更しても標準言語のままで表示され、言語変更が反映されませんでした。 今回のアップデートにより、そのような一部項目にも言語変更を適用できるようになります。
                                                                                                  • Zoho Visual Editor Not Opening

                                                                                                    Hello There I am trying to build a website using zoho and I can't open the visual editor. It keep saying Loading...  Do you know why it is happening. Thanks in Advance Regards Rajat
                                                                                                  • Customer Statement Template

                                                                                                    Hi. how can i add order number "customer LPO number" in the customer statement. regards
                                                                                                  • Linking an email to a Contact when the email is sent in deluge via sendmail

                                                                                                    The "to:" address in this code is a CRM Contact. Email address is forced unique in CRM This sendmail gets sent via a workflow which is in a custom module. It works, except that the outbound email does not appear (i.e, get linked to) the Contact such that
                                                                                                  • Introducing Bot Filtering for Accurate Email Campaign Analytics

                                                                                                    Dear Marketers, We're excited to announce a new feature designed to enhance the accuracy of your email campaign analytics: bot filtering. This feature helps you filter out bot-generated opens and clicks, ensuring your campaign reports reflect genuine
                                                                                                  • Edit HTML of forms? Add autocomplete="off"?

                                                                                                    Recently I've noticed that something — one customer suggested it was Chrome — is auto-filling one of my form fields with the customer's address. The field is a textarea that has nothing to do with the address — it's just a comment field. I'd like to be
                                                                                                  • All notes disappeared

                                                                                                    I've been using the notebook app for over five years on my phone without being logged into an account. A few days ago I opened the app and all my notes had disappeared. Since then I tried restarting my phone, updating the app and logging into my account,
                                                                                                  • Function 56: Automatically enable the option for customers to pay via bank account

                                                                                                    Hello everyone and welcome back to our series! One of the key features of Zoho Books is its integration with multiple payment gateways, allowing you to receive online payments for your invoices. This ensures faster payments, automates payment tracking
                                                                                                  • Issues hosting Zoho Desk Web Form on SharePoint and/or Power BI

                                                                                                    Zoho Desk onboarding support has no experience with embedding their web form in either SharePoint or Power BI. Microsoft states that SharePoint and Power BI only support iframe HTML. And unfortunately, the web form embed code that Zoho generates is not
                                                                                                  • Standalone function is not working

                                                                                                    Hi, We have created a standalone function to integrate with a third-party service using OAuth. However, the standalone function's REST API key is expiring automatically after some time. When we regenerate the API key from the admin account, the function
                                                                                                  • Function went from fine to nonfunctioning without change

                                                                                                    url = "https://www.zohoapis.com/crm/v7/Accounts/" + id + "/Attachments/" + attach_id; file_engage = invokeurl [ url :url type :GET connection:"zoho_attachments" ]; The attach id is grabbed from a file upload field account = zoho.crm.getRecordById("Accounts",id);
                                                                                                  • Can I give access of my Zoho Spreadsheet?

                                                                                                    Hello Everbody! I work with a travel and tourism company, and my job is to record the data of clients of the company. And I use zoho for my work. So my question is can I give access of my sheet to the clients and my company. Kindly guide me. Thankyo
                                                                                                  • Syncing Fields Between Accounts AND Deals

                                                                                                    Please don't email me, I will check this thread for updates daily. I have a custom set of 10 fields (CFSET) in my account pages and deals pages. I want to fill them out on accounts pages per each, then when I make a new deal in an account, I want to copy
                                                                                                  • Domain verification is in progress... (How long do I need to wait?)

                                                                                                    Trying to setup my first email domain by connecting with GoDaddy. Have been here for quite some time and the screen is not changing. How long should this take?Send DataSend Data
                                                                                                  • This mobile number has been marked spam. Please contact support.

                                                                                                    Hi Support, Can you tell me why number was marked as spam. I have having difficult to add my number as you keep requesting i must use it. My number is +63....163 Or is Zoho company excluding Philippines from their services?
                                                                                                  • Unable to send message;Reason:553 Relaying disallowed. Invalid Domain

                                                                                                    Team, When i try to send mail through ZOHO mail i am getting the following error. "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" Can i get some help on this. Thanks
                                                                                                  • Zoho mail stopped receiving emails

                                                                                                    My Zoho email addresses that are linked to a domain suddenly stopped receiving messages yesterday, even though I've been using Zoho mail without problems for 1,5 years. I receive this reply to test emails: "553 Relaying disallowed". Due to this, my SMTP
                                                                                                  • Email client fails to connect to IMAP & POP EU Servers for ALL users

                                                                                                    For the last couple of days, all users on my account are failing to connect to the Zoho EU mails servers. This is using mobile app on various phones & desktop mail clients on different computers. Everything works fine when using webmail & email is still
                                                                                                  • Zoho Project API search?

                                                                                                    Good day, i would like to search our entire portal for a task using the API. We have over 20k tasks so I dont to search for all tasks and then do a for each as it would take way to long and also would need to go over the limit of 200 records per query.
                                                                                                  • My email client shows no emails anymore

                                                                                                    I let my account expire due to old payment method. I repurchased it I turned back on IMAP Then all my emails disapeared. Everything is fine in the webview and and zoho mail app
                                                                                                  • Invalid Domain

                                                                                                    Team, When i try to send mail through ZOHO mail i am getting the following error. "Unable to send message;Reason:553 Relaying disallowed. Invalid Domain" Can i get some help on this. Thanks
                                                                                                  • URGENT - Issue with outgoing mail

                                                                                                    I am receiving mail but atm can not send - and not being given any code/reason as to why?
                                                                                                  • Impossible d'envoyer un message :Raison :553 Relaying disallowed. Invalid Domain - masertech.ma

                                                                                                    Bonjour, J'ai renouvelé mon abonnement mais j'ai le probleme de domain.
                                                                                                  • Email SPF Hard Fail

                                                                                                    Hi, can you help me to understand why email rejected? Paste error: This is the mail system at host pdx1-sub0-mail-mx206.dreamhost.com. I'm sorry to have to inform you that your message could not be delivered to one or more recipients. It's attached below.
                                                                                                  • Can I export to PDF in Zoho Learn

                                                                                                    I have seen help pages where export to pdf options are available but I do not see that option available from the application. I see that exprt is available in my free trial version but that is only to html pages. I need to be able to export my manuals
                                                                                                  • COQL equivalent to zoho.crm.getRelatedRecords

                                                                                                    Hello i add a standalone function, that i call from my js app with ZOHO.CRM.CONNECTION.invoke etc in the function i fetch with something like this AllContacts = zoho.crm.getRelatedRecords("relation_name","parent_module_name",recordid); it works great
                                                                                                  • Add option "Avoid custom home pages" to profiles

                                                                                                    We need our sales agents and members on each department in general to keep the same Home designed by their Managers. Let all users to create custom home pages is a huge mistake. The homepage creation must be limited by profile so only Managers are allowed
                                                                                                  • why is zoho assist server so slow

                                                                                                    Hello why is zoho assist server so slow, i use it every and and have fast speed at either end of the connection but zoho assist take upto 10 seconds per click, I connect on the chat they we will have a look and come back saying they have done a reset
                                                                                                  • WHEN UPDATE ORGANIZATION INFO OLD INVOICES ALSO CHANGE INVOICING DATA

                                                                                                    Hi We have updated our tax information because we have become a company, up until now we were an individual. The problem is that when updating the data in the zoho books profile all the old invoices change their tax information as well. Is there a way
                                                                                                  • DELETE EU VAT ID FORM MY ACTUAL INVOICE ADDRESS FROM MY ACCOUNT

                                                                                                    WE NEED TO DELETE (NOT CHANGE) THE EU VAT ID FROM OUR INVOICE ADDRESS. WHEN WE TRY TO LEFT IT BLANNK, AGAIN SAVE THE OLD EU VAT ID. YOU ARE SENDING US FALSE INVOICES WITH FALSE DATA
                                                                                                  • Enable Timesheet for Client Users

                                                                                                    In Zoho Projects, the client users can log work hours in timesheets and track the time spent on tasks and issues. This permission can be enabled only by the portal owner or the admin. For instance, If the administrator wants a client user to add the time
                                                                                                  • Possible to delete the "Big Deal Alert" in Zoho CRM?

                                                                                                    Hi, Is it possible to delete the "Big Deal Alert" in Zoho CRM? My company has no need for it and I want to remove it to clean up my email templates list. Thank you.
                                                                                                  • How to Create and Edit Advances in Zoho Expense Using Deluge?

                                                                                                    Hi everyone, I am working with Zoho Expense and need to manage Advances (Advance Payments) using Deluge. I’ve familiarized myself with some basic functions, but I have specific questions about how to create and edit advance records: Creating Advances:
                                                                                                  • ¿Cómo publicar mi pagina web zoho?

                                                                                                    Arme una pagina web en zoho, al querer publicarla seguí los pasos y pulse en publicar, pero no se publico. Ya pasaron 2 días. podían ayudarme.
                                                                                                  • What's New in Zoho Analytics - December 2024

                                                                                                    Hello Users! We’re excited to bring you a roundup of the latest features and improvements in Zoho Analytics. These updates are designed to elevate your data analytics experience, making it more powerful, interactive, and seamless. Let’s dive in! Expanded
                                                                                                  • Setting default From address when replying to request

                                                                                                    At the moment, if I want to reply to a request, the From field has three options, company@zohosupport.com, support@company.zohosupport.com, and support@company.com.  The first two are really internal address that should never be seen by the customer and
                                                                                                  • Zoho Sheet View

                                                                                                    Hello, Is there a way to either customize the columns that appear in Zoho Sheet View, or else show all columns?
                                                                                                  • For security reasons your account has been blocked as you have exceeded the maximum number of requests per minute that can originate from one account.

                                                                                                    Hello Zoho Even if we open 10-15 windows in still we are getting our accounts locked with error " For security reasons your account has been blocked as you have exceeded the maximum number of requests per minute that can originate from one account. "
                                                                                                  • Next Page