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.

      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

                                            • 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,


                                            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 WorkDrive Resources



                                                                      Zoho Campaigns Resources

                                                                        Zoho CRM Resources

                                                                        • CRM Community Learning Series

                                                                          CRM Community Learning Series


                                                                        • Tips

                                                                          Tips

                                                                        • 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