How to Insert a Flag Image in Excel

To insert a flag image in Excel for Microsoft 365 on Windows, select a cell, choose Insert > Pictures > This Device, select an image file, and choose Insert. Resize it with a corner handle, then set it to move with cells if you want it to stay aligned as the worksheet changes. You will need a flag image saved on your device, or access to an image source such as Excel’s available stock images.

What You’ll Need

A flag image file. PNG and JPEG files are common choices. PNG works well for a flag with a transparent background; JPEG is suitable for a regular rectangular image. Check that the image is clear enough to remain recognizable at the size you plan to use.
Excel for Microsoft 365 on Windows. The steps below use that version. Excel for Mac and Excel for the web have similar picture-insertion options, though the names and locations can differ slightly.
Permission to use the image. If the workbook will be shared, published, or used commercially, check the image’s license and any source requirements. A flag’s design may be familiar, but a particular digital image can still have usage conditions.

Step-by-Step

Choose where the flag should appear. Open the workbook and go to the worksheet where you want the image. Decide whether it should sit beside a country name, within a report, or in a separate header area. If you are making a country list, it is often useful to reserve a narrow column for flags and a wider column for country names. Adjust the column width and row height before inserting several images, if you already know the layout you want.
Get a suitable image and save it. Download or otherwise obtain a flag image from a source you are permitted to use. Save it somewhere easy to find, such as a project folder or your Pictures folder. Give the file a descriptive name, such as Japan-flag.png, rather than a generic name like image1. This makes it easier to select the correct file if you are adding many flags. Avoid copying an image from a webpage if you are unsure whether the copy method preserves the resolution or transparency.
Select the target cell. Click the cell near the position where the flag should sit. Inserting a picture does not put it inside the cell as text; in the standard insertion method, Excel places it as a floating object over the worksheet. Selecting a cell first gives you a useful reference point, but the image can still be moved independently. If the exact cell position matters, note its column and row so you can align the image after insertion.
Insert the picture from your computer. On Windows, select Insert > Pictures > This Device. In the file picker, browse to the image, select it, and choose Insert. The image appears on the worksheet, usually at its original or a default size. If your Excel build offers Insert > Pictures > Place in Cell, you can choose that option and then select the image file to put the image into the selected cell. The exact availability of Place in Cell depends on the Excel version and update channel; use the standard This Device option if it is not shown.
Use an online or stock image if appropriate. If you do not have a local file, check the available options under Insert > Pictures, such as stock images or online pictures, if they appear in your version. Search for the country name and flag, preview the result, and insert only an image that is appropriate for your use. The online picture options and licensing details can vary. If a suitable result is not available, find an image from a trusted source in a browser, save it, and insert it with This Device.
Resize the flag without distorting it. Click the picture so that its sizing handles appear. Drag a corner handle inward or outward to change both dimensions together and retain the flag’s proportions. Avoid dragging a middle handle on an edge, which can stretch the image horizontally or vertically. For a more consistent table, make the images the same height and use the corner handles to keep their proportions; different national flags do not all have the same shape, so their widths may naturally differ.
Position it over the intended cell. Drag the picture so it sits within the cell area you chose. Use the worksheet gridlines as guides. If it is hard to position precisely, zoom in using the zoom control at the bottom of the Excel window, move the image, and zoom back out. Leave a small margin around the flag rather than placing its edges directly on cell borders. This makes the sheet easier to read and reduces the chance that the image looks crowded.
Choose how it behaves when cells change. By default, a floating picture may not resize or move exactly as you expect when you edit rows or columns. Right-click the image and choose Size and Properties. In the formatting pane, open Properties and choose Move and size with cells if the flag should follow its cell and resize when the row or column changes. Choose Move but don’t size with cells if it should follow the cell but keep its dimensions, or Don’t move or size with cells if it should remain fixed on the sheet. The wording or pane layout can vary slightly by build.
Check the result in the worksheet. Click a different cell to finish editing the picture, then adjust the row height or column width if needed. Confirm that the flag is not covering a label, formula result, or another image. If it will be printed, use File > Print to inspect the print preview. A picture that looks aligned on screen may be clipped or positioned differently on a printed page if the print area or scaling settings are unsuitable.
Save the workbook and verify it reopens correctly. Press Ctrl+S on Windows and check that the file is saved in a format that supports pictures, such as .xlsx. Close and reopen the workbook if the image is especially important or the file will be sent to someone else. This quick check helps catch problems with a missing image, unexpected placement, or a saved copy that is not the one you intended to share.

On a Mac, select the cell, then use Insert > Pictures and choose an available option such as a picture from a file. The labels may differ by Excel for Mac version. In Excel for the web, use Insert > Pictures and choose a source offered in the ribbon; local-file and in-cell options depend on the current web version. If a command is missing, use the standard picture option that your version provides, then resize and position the image on the sheet.

Common Mistakes

Expecting a normal inserted picture to behave like cell content. A floating picture can cover multiple cells and does not automatically become part of a cell’s value. Use Place in Cell when your version offers it and you want an image stored in the cell, or set the floating picture’s cell properties to control how it responds to row and column changes.
Resizing from an edge handle. This can make a flag look squashed or unusually wide. Use a corner handle to maintain proportions. If the flag still appears distorted, reinsert the original image rather than trying to correct a severely stretched copy.
Making pictures too large or too small. A tiny image can be hard to recognize, while a large one may hide data and increase workbook size. Pick a practical display size, then check the sheet at normal zoom and in print preview.
Using inconsistent sizes in a list. Flags have different aspect ratios, so equal widths can result in noticeably different heights. For a neat column, use a consistent height and allow widths to vary, or create a uniform picture area and position each image consistently within it.
Assuming an online image is free to reuse. Being able to view or insert an image does not automatically grant permission to redistribute it. Check the source’s terms, particularly before sharing a workbook publicly or using it in paid materials.
Forgetting the image when sharing the workbook. A picture inserted into a standard .xlsx workbook is generally stored with the workbook, but a link to an external picture may depend on access to that file or location. Prefer inserting a local image when you need the workbook to remain self-contained.

Tips

Plan a flag column. Keep flags in one narrow column and text labels in the next. This makes sorting and scanning a country list easier. Leave enough row height for the image and use the same alignment approach for each entry.
Use one source and a consistent visual style. A collection of flags with different backgrounds, borders, or image quality can look uneven. Where practical, use clean rectangular images with similar resolution and no extra text or decorative framing.
Keep a copy of the original files. If you need to replace a flag or create a different-sized version later, the original makes it easier to start again without relying on a compressed or distorted copy extracted from the workbook.
Consider a cell-based layout before adding many images. If your Excel version includes Place in Cell, it can make an image behave more like content in a table and may simplify sorting or resizing rows. Test it with a few entries first, especially if the workbook will be opened in older Excel versions or other spreadsheet apps.
Use descriptive alt text when accessibility matters. Select the picture and look for the alt-text command in the picture context menu or Picture Format options. Add a short description such as the country name and flag, rather than relying on the file name. This helps people using screen readers understand the image’s purpose.
Think about printing and file size. High-resolution images can make a workbook larger than necessary. Use a clear image sized for its intended display, and review print preview if the sheet is meant for paper. Avoid reducing the image so much that its details become unclear.

Troubleshooting

The Pictures command is missing or looks different. Make sure you are in a worksheet and check the Insert tab. In a narrow window, some ribbon commands may be collapsed into menus. Maximize Excel or open the relevant ribbon menu. Mac and web versions may offer different source choices, so look for the general Pictures command rather than expecting the Windows label to match exactly.
The image will not insert. Confirm that the file exists and opens outside Excel. Try a common format such as PNG or JPEG, then repeat Insert > Pictures > This Device. If the workbook is in Protected View or you lack editing permission, enable editing only if you trust the file and have permission to make changes.
The flag moves when you change a row or column. Right-click it, open Size and Properties, and choose the property setting that matches your intention. For a flag that should stay attached to its row but not change size, select Move but don’t size with cells. For an image that should keep a fixed position, select Don’t move or size with cells.
The flag is cut off or hidden. Select it and drag a corner handle to make it smaller, or increase the row height and column width. If another object or cell content is in front of it, move the image or use the picture arrangement options to change its order. Check that the image is not positioned beyond the visible print area.
The picture looks stretched. Undo the last resize with Ctrl+Z on Windows, or reinsert the original if the distortion has already been saved. Resize from a corner handle. On Mac, use Command+Z to undo. If you need exact dimensions, enter them in the picture’s size controls and keep its aspect ratio locked where that option is available.
The picture is missing on another computer. Check that you inserted the image into the workbook rather than using a link to a file that exists only on your computer. If the image came from a shared location, confirm that the recipient has access. Save the workbook, reopen it, and test the actual file you plan to send.
The flag looks different in print. Open File > Print and review the preview. Check the selected printer, page orientation, scaling, margins, and print area. Adjust the image or page layout, then preview again before printing the full worksheet.

Frequently Asked Questions

Can I put a flag image inside a single Excel cell?
Yes, if your Excel build offers Insert > Pictures > Place in Cell. Choose the image source and insert it into the selected cell. If that command is unavailable, insert a regular floating picture and position it over the cell; it remains an object rather than a cell value.

Can I insert a flag from a website?
You can use an online-picture option if it is available in your version, or save an image file from a permitted source and insert it from your device. Check usage terms before distributing the workbook. If saving from a webpage, make sure you select the actual image file at a useful resolution.

How do I add several flags consistently?
Insert each image, resize using corner handles, and align them within the same column. Use a consistent height and similar margins, allowing widths to differ to preserve each flag’s proportions. For a large list, test Place in Cell if available and confirm that the images sort and display as you expect.

Will the flag stay in place when I sort the table?
A floating image may not sort with the row’s text unless it is positioned and configured appropriately, and behavior can depend on the table layout and Excel version. Set its properties to move with cells, then test sorting a small sample. A Place in Cell image, where available, is often a better fit when images must travel with cell data.

Can I make the image round or change its shape?
You can crop or format a picture using the options on the Picture Format tab, but a flag is usually clearest in its original rectangular proportions. Cropping to a different shape can remove part of the design, so use it only when that visual treatment is intentional.

Does inserting a flag change the cell’s value?
A standard floating picture does not change the selected cell’s value; it sits above the grid as a separate object. Place in Cell, when available, stores the image in the cell’s image content, but it is still not ordinary text such as a country name.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.