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 Marketing Automation
                                • Sticky Posts

                                • New Toolbar in Zoho Sheet

                                  We have revamped our toolbar design in this new version of Zoho Sheet. Below are some screenshots to help you get accustomed to this new interface. Click on the picture below to view the animated image in its original size. Scroll down this post to learn about the changes. Highlight of Changes: The previous format tab is now split into 2 tabs - Home and Format. The Home tab contains the commonly used functions and the Format tab holds formatting related options. Under the Home tab towards the far
                                • 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
                                • Introducing 15 new Zoho Sheet functions

                                  Zoho Sheet supports more than 350 predefined functions across a wide range of categories, like Text, Financial, and Spreadsheet. We released the LAMBDA function in 2021. Now, we are adding more LAMBDA functions, along with some highly convenient text
                                • Introducing Forms in Zoho Sheet

                                  We hereby bring you the power of ​forms in Zoho Sheet. ​Now, build and create your own customized forms using Zoho Sheet. Be it compiling a questionnaire or rolling out a survey, Zoho Sheet can do it all for you. Forms is an excellent feature that helps you collect information in the simplest of ways and having it in Zoho Sheet takes it a notch higher. Build Simple yet Powerful forms Building forms using Zoho Sheet is fairly simple. The exclusive 'Form' tab lets you create one quickly. Whether you
                                • Collaborative spreadsheets on your smartphone.

                                  Waiting till you're at your laptop to get your work done is a thing of the past. Stay on track with the mobile world with the Zoho Sheet app for iPhone, iPad, and Android devices—watch the video. Now you can:   View and access all your spreadsheets—both owned and shared. Perform calculations in a snap with more than 350 functions.  Visualize data with charts and conditional formats. Share and collaborate in real time with your team. Distribute files with shareable links. Insert hyperlinks, checkboxes,


                                Manage your brands on social media



                                        Zoho TeamInbox Resources

                                          Zoho DataPrep Resources



                                            Zoho CRM Plus Resources

                                              Zoho Books Resources


                                                Zoho Subscriptions Resources

                                                  Zoho Desk 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

                                                                • Word of the Day

                                                                  Word of the Day



                                                                      Design. Discuss. Deliver.

                                                                      Create visually engaging stories with Zoho Show.

                                                                      Get Started Now