GIF image Header

here is failsafe way to use images in google sheets


put images in a shared folder on google drive

right click images - & get sharable link

paste that link into cell - in example below column F5:F8

formula to put image in cell can be a single cell - or array formula in B5


for single image

=If(F5="",,Image("http://drive.google.com/uc?export=view&id="&mid(F5,34,33),2))


an arrayformula for a column of images

=Arrayformula(If(F5:F8="",,Image("http://drive.google.com/uc?export=view&id="&mid(F5:F8,34,33),2)))