AppsCare | Add an image into frozen sections in Google Sheets
AppsCare is a Google for Work Premier Partner in the UK and specialises in the deployment of Google Apps for Work, Google Drive for Work, Google for Education, Google Maps for Work, Chrome Devices for Work and Google Search.
google enterprise premier partner, google enterprise partner, google enterprise reseller, google apps reseller, google apps partner, google maps reseller, google maps partner, chromebooks reseller, chromebox for meetings, google maps for business, google apps for business, google apps for education, google drive for work, drive for work, google for work, google apps for work, google maps for work, chrome for work, google for work premier partner, google apps for work reseller, uk, google for work uk premier partner, google apps reseller, google apps partner
single,single-post,postid-17574,single-format-standard,ajax_fade,page_not_loaded,,wpb-js-composer js-comp-ver-4.0.5,vc_responsive

15 Jan Add an image into frozen sections on Google Sheets

How to add an image into the frozen section on Google Sheets: Announced this week, Google have now added the functionality to be able to add an image into frozen rows or columns in Google Sheets, to help smarten up your documents. Here’s our easy steps to get started. 

Firstly, you will want to freeze your selected column or rows, if you haven’t done already. These sections can either contain data or be blank, in this instance we have left blank. Head to ‘View’ on the menu and choose to either freeze rows or freeze columns. In this example we are freezing 4 rows to create a header area.

Google Apps Tips: Google Sheets Freeze Rows

If you are wanting to do the same and create a header area for your page, then you might also want to change the borders in this area to white, to get a flat colour with no gridlines. To do this, you need to highlight the selected area, then click on the borders button as shown below, change the colour to white and select ‘All borders’.

Google Apps Tips: Google Sheets Grid Colour

Now time to add your image. Make sure your cursor has a cell selected within the frozen section where you would like your image to be placed, as there is not much freedom for moving the image once placed. To add your image, click ‘Insert’ and scroll down to ‘Image…’

Google Apps Tips: Google Sheets Insert Image

You can choose an image to upload or insert an image via Google Drive. Resize your image as required once placed to achieve the desired look.

Google Apps Tips: Google Sheets Image in Frozen Sections

Once you have inserted your image, you can replace or delete it. Select the image and click on the drop down arrow in the top right hand corner of the image box, and select from one of the options.

Google Apps Tips: Google Sheets Reset Image


For more tips like this, visit our Google Apps Tips blog or for more information or help with your Google account, contact our team via email at

Claire Stead
No Comments

Post A Comment