There are pictures and text in Excel. Will the position of the pictures be messed up after translation?
After the Excel translation with mixed images and text, the images may be misaligned due to changes in row height, column width or merged cells. This article explains common causes and gives pre- and post-translation inspection steps and preventive practices.
Key points of this article
- Whether the picture follows the cell depends on its positioning method. Pictures floating above the table are easily misaligned.
- The translation is usually longer than the original text. When the cell cannot fit, it will wrap or raise the row, and the image position will shift accordingly.
- Merging cells and hiding rows and columns will make it difficult to correspond to image anchors. Try to simplify the table structure before translating.
- Back up the original files before translation. After translation, check the relative positions of the images and text one by one before deciding whether to deliver them.
- OmniDoc will retain images when translating Excel, but the layout should still be checked against the original document and important content should be checked.
If you have an Excel copy in your hand, which contains product descriptions, screenshots, flow charts, or photos. What you worry about before translating is often not whether the translation is accurate, but whether the pictures will move to other cells. A form is a combination of "text + picture". After translation, the text has changed in length. Can the picture still stay in its original position? This article is written for those who need to translate forms with mixed graphics and text, especially those who want to hand over quotations, product catalogs, and training materials to foreign colleagues.
The good news is that image misalignment is usually not caused by translation itself, but by changes in text length, stretched row height and column width, and different ways of positioning images. As long as you understand how the picture is "hanged" on the form, most problems can be prevented in advance and can be checked quickly after translation.
After the graphics and text are translated in Excel, will the pictures be messy? One sentence conclusion
Whether the image will be messy or not depends on whether it is embedded in the cell or floating above the table, and whether the translation heightens or widens the cell; OmniDoc will retain the image when translating Excel, but you should still check the position against the original file before delivery. The table below can help you quickly choose a method.
| your situation | Recommended practices | The reason |
|---|---|---|
| The image floats above the table and is not associated with the cell | Before translation, adjust the image to the nearest cell and set it to move with the cell | Floating pictures do not follow the cells, and the text is easily misplaced when it becomes longer. |
| The table contains a large number of merged cells | Before translation, split unnecessary mergings or merging only the title line | After the merge area changes, it is difficult for the image anchor point to correspond to the correct position. |
| The translation is obviously longer than the original text, such as Chinese to English | Check row height and column width after translation and manually widen columns if necessary | Wrapping the text will raise the line, and the image and subsequent content will be offset accordingly. |
| The table has only a few pictures and a simple layout | Upload translations directly and check them one by one after downloading | When the structure is simple, the effect of preserving images is usually more stable |
| It needs to be handed over for others to use | First, translate it into a copy, verify for accuracy, then send it, and keep the original file | Once misaligned, the cost of modification is much higher than pre-backup |
First, determine which type of problem it is
There are many manifestations of image misalignment, and the causes vary. Take a quick look before and after the translation, identify the symptoms first, and then decide how to fix them.
| Symptoms | Common causes | How to confirm this |
|---|---|---|
| The overall image shifts downward or to the right | The text at the top gets longer, the row height is stretched out, and the floating image doesn't move with it | Compare the row height of the same line between the original file and the translation, and see if the distance between the image and the text on the left has changed |
| The image covers the text, or the text is covered by the image | The image size remains the same, but the cell content increases, or the column width narrows | Click each cell one by one to see if the image boundary covers the area where the text is located |
| A certain image runs into an adjacent table or worksheet | Merging cells or hiding rows and columns changes anchor points, causing image positioning datums to become invalid | After unhiding rows and columns, observe or check if the image is placed at the edge of the merged area |
| Images become blurry or compressed | Compression is set when exporting or converting, not a matter of position | Zoom in to view the clarity of the original and translated images to distinguish between position and image quality |
| The images do not appear in the corresponding positions but are concentrated at the beginning of the table | The image was not properly anchored in the original file and was itself floating | Check whether the image in the original file is actually hanging on the target cell |
Inspect and fix each item one by one
It is recommended to handle them in the order of easy and difficult ones; most problems can be resolved in the first few steps.
- Back up the original file before translation and note down the images that need to be maintained. You can write in the remarks which row or column each image corresponds to, making it easier to verify after translation.
- Check if the image is floating. Select the image in Excel and check its property settings. If it's not "Move with Cells," adjust it to "Move with Cells," then drag the image near the corresponding cell.
- Check the merged cells. Avoid merging whenever possible, especially in the areas near the rows and columns where the image is located. Header rows can be merged, and it is recommended to keep the data areas separate cells.
- Estimate the length of the translation. Translating from Chinese to English usually results in longer columns, so you can slightly widen the column width before translation or reserve higher row heights for the row in the image.
- Upload the original .xlsx file to the omnidoc.top, choose bilingual or translation only, and wait for processing to finish before downloading the result. Bilingual verification is suitable; only the translation is suitable for direct delivery.
- Open the translation file and check each image one by one: whether the image is still in the corresponding cell, if it is covered by text, and whether it appears in adjacent tables. After finding the issue, directly adjust line height, column width, or image position within the translation.
- Check the text within the image. The text in screenshots or flowcharts may not be translated along with the main text; you need to verify by comparing with the original image yourself, and if necessary, use a common method to handle it separately.
- Only deliver after confirming everything is correct, and keep both the original document and the translation.
Misalignment caused by image floating
This is a common situation. The image isn't anchored to the cell; when the text changes, the image stops at its original absolute position, looking like it's "running." The solution is to set the image to move with the cells, then place it back into the corresponding cell. If there are many images in the table, you can check each page before translation, which saves more time than editing each page after translation.
Misalignment caused by merging cells
Merging cells changes the reference points of rows and columns, and the reference position of the image changes accordingly. If you find a large merge area near the image before translation, it's recommended to split it first or move the image to a separate area that does not merge. After translation, pay special attention to the images at the edges of merged areas, as they tend to shift easily.
Overflow caused by longer translations
Short Chinese and long English are common. After a line break in translation, the cells will automatically be raised or text will overflow, overflowing onto adjacent images. The solution is to manually widen columns or increase line height after translation, and make sure the image is not overwritten by text. If the table has many columns, consider reducing the text per row or splitting long passages into adjacent rows.
How to Prevent It from Happening Next Time
- When creating the table, set the image to move with the cells to avoid later realizing the image is floating.
- Leave blank lines or columns between images and text to allow for longer translations.
- Try to minimize the use of merged cells, especially around the picture. Header rows can be merged, and data areas are recommended to be independent.
- Centralize images in one area or in a separate worksheet for unified inspection and adjustment.
- Back up the original file before translation, keep a copy of the translation after translation, and save both versions together. If any issues arise, you can compare and modify them.
- The content of machine translation needs to be verified; important prices, models, dates, and terms should be compared with the original text item by item, not just by the formatting.
❓ Frequently Asked Questions (FAQ)
1. Will images become blurry after translation?
Image quality depends on the original image and export settings, not the translation itself. Before translating, you can check the clarity of the original image, then zoom in for comparison after translation. If the change is obvious, consider replacing it with a clearer image.
2. Can scanned versions of Excel translate like this?
Excel files are usually editable tables, not scans. If you have a printed and scanned PDF table, first check if there is selectable text; if not, first perform recognition and then adjust the position of the text and images.
3. Will the text in the images be translated?
It cannot be generalized. The text in the table cells is the main translation target, while the text embedded in the image should be translated and checked against the original image separately, and handle it yourself if necessary.
4. Is there a way to keep the image position unchanged without modifying the original file?
There is no single method to ensure that the image positions in all tables remain 100% unchanged. A safer approach is to prepare before translating, check each item afterward, and adjust if there are any issues.
📝 Summary
After Excel translations with mixed text and images, image misalignment mostly comes from floating positioning, merging cells, and longer translations. Checking these three points in advance can help avoid most problems. Backing up before translation, checking each item individually after translation, and manually reviewing important content is a reliable way to handle Excel text + image tables, and it is also a key step in Excel document translation that is often overlooked but is crucial.


