Now let\u2019s break it down. In simple steps. With no spreadsheet stress.<\/p>\n
Why Images Jump Around in Google Sheets<\/strong><\/h2>\nFirst, you need to understand the problem.<\/p>\n
Google Sheets lets you insert images in two main ways<\/em>:<\/p>\n\n- Image in cell<\/strong><\/li>\n
- Image over cells<\/strong><\/li>\n<\/ul>\n
This choice matters a lot.<\/p>\n
If you choose Image over cells<\/strong>, the picture floats. It is not tied to one specific cell. When you resize rows or columns, the image may overlap other cells. It might move slightly. It might spill into the next column.<\/p>\nThat is usually the reason images refuse to stay in a single column.<\/p>\n
If you choose Image in cell<\/strong>, the image behaves like text. It stays inside the cell. It moves with the row. It resizes with the column.<\/p>\nThis is your best friend.<\/p>\n
The Easiest Way: Use \u201cImage in Cell\u201d<\/strong><\/h2>\nLet\u2019s start with the simplest trick. The one that fixes most problems.<\/p>\n
To insert an image correctly:<\/p>\n
\n- Click the cell where you want the image.<\/li>\n
- Click Insert<\/strong> in the top menu.<\/li>\n
- Choose Image<\/strong>.<\/li>\n
- Select Image in cell<\/strong>.<\/li>\n<\/ol>\n
Done.<\/p>\n
The image now belongs to that column. It will not float into the next one.<\/p>\nImage not found in postmeta
\n
Pro tip:<\/em> Always create a dedicated column just for images. Do not mix images and long text in the same column. That keeps your sheet cleaner and easier to control.<\/p>\nControl Column Width the Smart Way<\/strong><\/h2>\nEven when you use \u201cImage in cell,\u201d layout still matters.<\/p>\n
If your column is too narrow, the image may look squished. If the column is too wide, the image may look stretched.<\/p>\n
Here\u2019s how to fix that:<\/p>\n
\n- Move your cursor to the line between column letters (for example, between A and B).<\/li>\n
- Click and drag to resize.<\/li>\n
- Or right-click the column letter and choose Resize column<\/strong>.<\/li>\n<\/ol>\n
Try to set a consistent width for your image column.<\/p>\n
For example:<\/p>\n
\n- Product thumbnails: 120\u2013150 pixels wide<\/li>\n
- Profile photos: 100 pixels wide<\/li>\n
- Larger visuals: 200+ pixels wide<\/li>\n<\/ul>\n
Consistency makes your sheet look professional.<\/p>\n
Adjust Row Height for Perfect Alignment<\/strong><\/h2>\nImages also depend on row height.<\/p>\n
If the row is too short, the image may look cramped. If different rows have different heights, your layout may look uneven.<\/p>\n
To fix row height:<\/p>\n
\n- Right-click the row number.<\/li>\n
- Select Resize row<\/strong>.<\/li>\n
- Enter a pixel value.<\/li>\n<\/ol>\n
Want everything uniform? Select multiple rows first. Then resize them all at once.<\/p>\n
This keeps every image aligned in one clean column.<\/p>\n![\"\"](\"https:\/\/unitconversion.io\/blog\/wp-content\/uploads\/2026\/02\/high-raise-building-adjusting-row-height-in-google-sheets-resize-row-menu-aligned-images-column.jpg\")
\n
When You Must Use \u201cImage Over Cells\u201d<\/strong><\/h2>\nSometimes you need more flexibility.<\/p>\n
Maybe you want:<\/p>\n
\n- A larger banner image<\/li>\n
- A logo above a table<\/li>\n
- A design element that spans multiple cells<\/li>\n<\/ul>\n
In that case, you will use Image over cells<\/strong>.<\/p>\nBut now you need extra control.<\/p>\n
How to Keep Floating Images Inside One Column<\/em><\/h3>\nTry these tricks:<\/p>\n
\n- Hold Shift<\/strong> while resizing to keep proportions.<\/li>\n
- Zoom in for precise placement.<\/li>\n
- Align the image edges exactly with column borders.<\/li>\n
- Avoid resizing columns after placing the image.<\/li>\n<\/ul>\n
If you resize columns later, floating images may shift slightly.<\/p>\n
So finalize your layout first. Then place the images.<\/p>\n
Freeze Columns to Prevent Visual Chaos<\/strong><\/h2>\nWhen working with many images, scrolling can make things confusing.<\/p>\n
Here is a neat trick: Freeze your image column<\/strong>.<\/p>\nTo do this:<\/p>\n
\n- Click on the column after your image column.<\/li>\n
- Go to View<\/strong>.<\/li>\n
- Select Freeze<\/strong>.<\/li>\n
- Choose Up to current column<\/strong>.<\/li>\n<\/ol>\n
Now when you scroll to the right, your images stay visible.<\/p>\n
This is perfect for:<\/p>\n
\n- Product catalogs<\/li>\n
- Inventory lists<\/li>\n
- Team directories<\/li>\n<\/ul>\n
It keeps your layout stable and easy to follow.<\/p>\n
Use the IMAGE Formula for Full Control<\/strong><\/h2>\nYes. There is also a formula for images.<\/p>\n
You can use:<\/p>\n
=IMAGE(“URL”)<\/strong><\/p>\nThis inserts an image from a web link directly into a cell.<\/p>\n
You can also control its size:<\/p>\n
=IMAGE(“URL”, 4, height, width)<\/strong><\/p>\nExample:<\/p>\n
=IMAGE(“https:\/\/example.com\/photo.jpg”, 4, 100, 100)<\/strong><\/p>\nThis forces the image to be exactly 100 by 100 pixels.<\/p>\n
Why is this powerful?<\/p>\n
\n- All images stay the same size.<\/li>\n
- Everything aligns perfectly in one column.<\/li>\n
- No manual resizing needed.<\/li>\n<\/ul>\n
This is fantastic for large sheets with dozens or hundreds of images.<\/p>\n![\"\"](\"https:\/\/unitconversion.io\/blog\/wp-content\/uploads\/2026\/02\/icon-google-sheets-image-formula-example-product-list-with-thumbnails-spreadsheet-with-uniform-images.jpg\")
\n
Avoid Merging Cells (Usually)<\/strong><\/h2>\nMerged cells can look nice.<\/p>\n
But they often cause layout headaches.<\/p>\n
Images inside merged cells may:<\/p>\n
\n- Shift unexpectedly<\/li>\n
- Resize oddly<\/li>\n
- Break alignment with other rows<\/li>\n<\/ul>\n
If you want a taller image space, it is usually better to:<\/p>\n
\n- Increase row height<\/li>\n
- Keep one cell per image<\/li>\n<\/ul>\n
Simple structure wins.<\/p>\n
Keep Text in Neighboring Columns Clean<\/strong><\/h2>\nAnother problem happens when text wraps badly.<\/p>\n
If text in nearby columns expands the row height automatically, your images may suddenly look stretched.<\/p>\n
To prevent this:<\/p>\n
\n- Set text wrapping intentionally (Wrap<\/strong>, Overflow<\/strong>, or Clip<\/strong>)<\/li>\n
- Use fixed row heights where possible<\/li>\n
- Keep descriptions concise<\/li>\n<\/ul>\n
Your image column will stay visually balanced.<\/p>\n
Create a Clean Catalog Layout<\/strong><\/h2>\nLet\u2019s say you are building a product sheet.<\/p>\n
Here is a smart layout structure:<\/p>\n
\n- Column A:<\/strong> Image<\/li>\n
- Column B:<\/strong> Product Name<\/li>\n
- Column C:<\/strong> Price<\/li>\n
- Column D:<\/strong> Status<\/li>\n<\/ul>\n
Steps for perfect alignment:<\/p>\n
\n- Resize Column A to a fixed width.<\/li>\n
- Resize all rows to a fixed height.<\/li>\n
- Insert images using \u201cImage in cell\u201d or the IMAGE formula.<\/li>\n
- Freeze Column A.<\/li>\n<\/ol>\n
Now everything stays in one tidy column. No surprises.<\/p>\n
Fixing a Messy Sheet<\/strong><\/h2>\nAlready have a messy sheet full of floating images?<\/p>\n
Don\u2019t panic.<\/p>\n
Here is how to clean it up:<\/p>\n
- \n
- Image in cell<\/strong><\/li>\n
- Image over cells<\/strong><\/li>\n<\/ul>\n
This choice matters a lot.<\/p>\n
If you choose Image over cells<\/strong>, the picture floats. It is not tied to one specific cell. When you resize rows or columns, the image may overlap other cells. It might move slightly. It might spill into the next column.<\/p>\n
That is usually the reason images refuse to stay in a single column.<\/p>\n
If you choose Image in cell<\/strong>, the image behaves like text. It stays inside the cell. It moves with the row. It resizes with the column.<\/p>\n
This is your best friend.<\/p>\n
The Easiest Way: Use \u201cImage in Cell\u201d<\/strong><\/h2>\n
Let\u2019s start with the simplest trick. The one that fixes most problems.<\/p>\n
To insert an image correctly:<\/p>\n
- \n
- Click the cell where you want the image.<\/li>\n
- Click Insert<\/strong> in the top menu.<\/li>\n
- Choose Image<\/strong>.<\/li>\n
- Select Image in cell<\/strong>.<\/li>\n<\/ol>\n
Done.<\/p>\n
The image now belongs to that column. It will not float into the next one.<\/p>\nImage not found in postmeta
\nPro tip:<\/em> Always create a dedicated column just for images. Do not mix images and long text in the same column. That keeps your sheet cleaner and easier to control.<\/p>\n
Control Column Width the Smart Way<\/strong><\/h2>\n
Even when you use \u201cImage in cell,\u201d layout still matters.<\/p>\n
If your column is too narrow, the image may look squished. If the column is too wide, the image may look stretched.<\/p>\n
Here\u2019s how to fix that:<\/p>\n
- \n
- Move your cursor to the line between column letters (for example, between A and B).<\/li>\n
- Click and drag to resize.<\/li>\n
- Or right-click the column letter and choose Resize column<\/strong>.<\/li>\n<\/ol>\n
Try to set a consistent width for your image column.<\/p>\n
For example:<\/p>\n
- \n
- Product thumbnails: 120\u2013150 pixels wide<\/li>\n
- Profile photos: 100 pixels wide<\/li>\n
- Larger visuals: 200+ pixels wide<\/li>\n<\/ul>\n
Consistency makes your sheet look professional.<\/p>\n
Adjust Row Height for Perfect Alignment<\/strong><\/h2>\n
Images also depend on row height.<\/p>\n
If the row is too short, the image may look cramped. If different rows have different heights, your layout may look uneven.<\/p>\n
To fix row height:<\/p>\n
- \n
- Right-click the row number.<\/li>\n
- Select Resize row<\/strong>.<\/li>\n
- Enter a pixel value.<\/li>\n<\/ol>\n
Want everything uniform? Select multiple rows first. Then resize them all at once.<\/p>\n
This keeps every image aligned in one clean column.<\/p>\n
\nWhen You Must Use \u201cImage Over Cells\u201d<\/strong><\/h2>\n
Sometimes you need more flexibility.<\/p>\n
Maybe you want:<\/p>\n
- \n
- A larger banner image<\/li>\n
- A logo above a table<\/li>\n
- A design element that spans multiple cells<\/li>\n<\/ul>\n
In that case, you will use Image over cells<\/strong>.<\/p>\n
But now you need extra control.<\/p>\n
How to Keep Floating Images Inside One Column<\/em><\/h3>\n
Try these tricks:<\/p>\n
- \n
- Hold Shift<\/strong> while resizing to keep proportions.<\/li>\n
- Zoom in for precise placement.<\/li>\n
- Align the image edges exactly with column borders.<\/li>\n
- Avoid resizing columns after placing the image.<\/li>\n<\/ul>\n
If you resize columns later, floating images may shift slightly.<\/p>\n
So finalize your layout first. Then place the images.<\/p>\n
Freeze Columns to Prevent Visual Chaos<\/strong><\/h2>\n
When working with many images, scrolling can make things confusing.<\/p>\n
Here is a neat trick: Freeze your image column<\/strong>.<\/p>\n
To do this:<\/p>\n
- \n
- Click on the column after your image column.<\/li>\n
- Go to View<\/strong>.<\/li>\n
- Select Freeze<\/strong>.<\/li>\n
- Choose Up to current column<\/strong>.<\/li>\n<\/ol>\n
Now when you scroll to the right, your images stay visible.<\/p>\n
This is perfect for:<\/p>\n
- \n
- Product catalogs<\/li>\n
- Inventory lists<\/li>\n
- Team directories<\/li>\n<\/ul>\n
It keeps your layout stable and easy to follow.<\/p>\n
Use the IMAGE Formula for Full Control<\/strong><\/h2>\n
Yes. There is also a formula for images.<\/p>\n
You can use:<\/p>\n
=IMAGE(“URL”)<\/strong><\/p>\n
This inserts an image from a web link directly into a cell.<\/p>\n
You can also control its size:<\/p>\n
=IMAGE(“URL”, 4, height, width)<\/strong><\/p>\n
Example:<\/p>\n
=IMAGE(“https:\/\/example.com\/photo.jpg”, 4, 100, 100)<\/strong><\/p>\n
This forces the image to be exactly 100 by 100 pixels.<\/p>\n
Why is this powerful?<\/p>\n
- \n
- All images stay the same size.<\/li>\n
- Everything aligns perfectly in one column.<\/li>\n
- No manual resizing needed.<\/li>\n<\/ul>\n
This is fantastic for large sheets with dozens or hundreds of images.<\/p>\n
\nAvoid Merging Cells (Usually)<\/strong><\/h2>\n
Merged cells can look nice.<\/p>\n
But they often cause layout headaches.<\/p>\n
Images inside merged cells may:<\/p>\n
- \n
- Shift unexpectedly<\/li>\n
- Resize oddly<\/li>\n
- Break alignment with other rows<\/li>\n<\/ul>\n
If you want a taller image space, it is usually better to:<\/p>\n
- \n
- Increase row height<\/li>\n
- Keep one cell per image<\/li>\n<\/ul>\n
Simple structure wins.<\/p>\n
Keep Text in Neighboring Columns Clean<\/strong><\/h2>\n
Another problem happens when text wraps badly.<\/p>\n
If text in nearby columns expands the row height automatically, your images may suddenly look stretched.<\/p>\n
To prevent this:<\/p>\n
- \n
- Set text wrapping intentionally (Wrap<\/strong>, Overflow<\/strong>, or Clip<\/strong>)<\/li>\n
- Use fixed row heights where possible<\/li>\n
- Keep descriptions concise<\/li>\n<\/ul>\n
Your image column will stay visually balanced.<\/p>\n
Create a Clean Catalog Layout<\/strong><\/h2>\n
Let\u2019s say you are building a product sheet.<\/p>\n
Here is a smart layout structure:<\/p>\n
- \n
- Column A:<\/strong> Image<\/li>\n
- Column B:<\/strong> Product Name<\/li>\n
- Column C:<\/strong> Price<\/li>\n
- Column D:<\/strong> Status<\/li>\n<\/ul>\n
Steps for perfect alignment:<\/p>\n
- \n
- Resize Column A to a fixed width.<\/li>\n
- Resize all rows to a fixed height.<\/li>\n
- Insert images using \u201cImage in cell\u201d or the IMAGE formula.<\/li>\n
- Freeze Column A.<\/li>\n<\/ol>\n
Now everything stays in one tidy column. No surprises.<\/p>\n
Fixing a Messy Sheet<\/strong><\/h2>\n
Already have a messy sheet full of floating images?<\/p>\n
Don\u2019t panic.<\/p>\n
Here is how to clean it up:<\/p>\n
- Column B:<\/strong> Product Name<\/li>\n
- Set text wrapping intentionally (Wrap<\/strong>, Overflow<\/strong>, or Clip<\/strong>)<\/li>\n
- Select Freeze<\/strong>.<\/li>\n
- Hold Shift<\/strong> while resizing to keep proportions.<\/li>\n
- Enter a pixel value.<\/li>\n<\/ol>\n
- Choose Image<\/strong>.<\/li>\n
- Image over cells<\/strong><\/li>\n<\/ul>\n