Place Images in Frozen Areas of Sheets

Some while ago in this post I talked about how to freeze areas of your spreadsheets in order to make presentation a little more slick.

Google has now released a small update to allow the adding of images to these frozen areas of a sheet, further enhancing the presentation possibilities. Here’s a sheet with the top few rows frozen:

Click image to enlarge

Click image to enlarge

Select a cell in the frozen area and choose Insert > Image from the menu:

Click image to enlarge

Click image to enlarge

The image will be overlaid on your sheet; move and resize it using its drag handles:

Click image to enlarge

Click image to enlarge

Once completed, your image will remain fixed within the frozen area of the sheet:

Click image to enlarge

Click image to enlarge