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.

    • Sticky Posts

    • Refine by Zia: a smart way to improve data quality

      Zia in Zoho Sheet has been helping users with recommended charts, pivot tables, and offering insights about their data. While there is an exclusive smart data cleaning tool, from now on Zia will also include data quality suggestions for error-free analysis,
    • Webinar: Learn how to instantly clean your spreadsheet data

      Hello! Do you find it tedious to get rid of duplicate entries, inconsistencies, and missing values in your data? Join our webinar and learn the trick to clean up your data in an instant. In this session you'll be introduced to the smart data cleaning tool in Zoho Sheet followed by a live demonstration.  ​ In this session, you'll get to know: What's new in Zoho Sheet About a smart tool to clean your spreadsheets in an instant How to find and remove duplicate records from your data How to get rid of
    • Announcing IMPORTRANGE and cross-spreadsheet linking in Zoho Sheet

      We are pleased to announce the much-requested IMPORTRANGE function in Zoho Sheet. With this function, you can now link or refer to cell ranges across spreadsheets in an instant.   Refer across spreadsheets You can use IMPORTRANGE just like any other predefined function in Zoho Sheet. Start with an equal sign, select the function, and fill in the parameters. For this function, the source spreadsheet link and the desired cell range to import are given as input.     Once you allow access to the source
    • Tab Colors and New Currency Symbol of Indian Rupee

      Zoho Sheet has recently added support for the following 2 new features: Tab Colors: Since last month, you can set a color to your worksheet tabs. Use colors to quickly identify/highlight specific worksheets or to group similar worksheets together. This option is available on the right click context menu of the worksheet tab. Add color to your worksheets! Indian Rupee Currency - New Symbol: The new Indian Rupee Symbol, ₹, is now supported in Zoho Sheet. This replaces the old "Rs." currency symbol
    • Expanding and securing ways to share your spreadsheet: email as attachment and password protection

      While Zoho Sheet allows you to share and collaborate with your colleagues in real time, you might wish to send your spreadsheets as email attachments or keep an offline version of a confidential file with password protection. Here's how our new options

      Zoho SalesIQ Resources

            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

                                                    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.