To send a picture to the back in Google Sheets, you typically use the "Order" option after right-clicking the image, provided the image was inserted "over cells."
Google Sheets allows you to insert images in two ways:
- Image in cell: The image is placed within a specific cell and behaves like cell content.
- Image over cells: The image floats freely on top of the grid and can be resized, moved, and layered over other elements like charts, shapes, or other images.
Ordering Images Over Cells
The method for sending an image to the back applies to images inserted "over cells." This process is similar to managing object layers in other Google Workspace applications like Google Slides.
Here's how to send an image over cells to the back:
- Select the Image: Click on the image you want to send behind other objects.
- Open the Context Menu: Right-click on the selected image.
- Access Ordering Options: In the menu that appears, hover your mouse over the "Order" option.
- Select "Send to back": From the "Order" sub-menu, click on "Send to back".
This action will move the selected image behind all other floating objects on the sheet, such as other images, charts, or drawing elements.
As described in documentation regarding Google Slides, a similar ordering mechanism is used for objects: "right-click on the image, go to Order, and select Send to back. This will place the image behind all other slide elements." The process for images over cells in Google Sheets functions in a comparable way, allowing you to control the stacking order of your visual elements.
You will also find other ordering options in this menu, such as:
- Bring to front: Moves the image to the very top layer.
- Bring forward: Moves the image one layer up.
- Send backward: Moves the image one layer down.
Images In Cells
Images inserted "in cell" cannot be layered or sent to the back using the "Order" menu. Since they reside within a cell, they function as background content for that specific cell and do not interact with other floating objects in terms of layering.
In summary, if your image is floating over the cells, right-clicking and using the "Order > Send to back" option is the correct way to place it behind other objects in Google Sheets.