There are at least two possibilities to insert an image into an Excel document, the first is to insert an image directly and the second is to insert an image in a form. In this article we will discuss both methods and show you how to apply transparency to the inserted image.
How to insert an image directly into Excel?
- Click on Insert > Image.
- You can enter the picture you want but if you enter an image of 1920 x 1088 pixel, Excel will display an image having the following dimension 1920 x 1088 cm.
- Another solution: Use an image control tool (OCX Controls), spread it on the sheet, right click and select Developer > Insert > Image and apply it to the sheet.
- Right click on the image and select Properties.
- Set PictureSizeMode = 3
- In the Properties window, go to Picture and select an image to be included in the control.
- So far the picture is inserted into the control while maintaining the width/height ratio. You can adjust the size of the control to coincide with the dimensions of the image. However it should be noted that transparency options are not available.
How to insert an image in a form?
- Click on Insert > Form.
- Draw the rectangle.
- Right click and select Format Shape. Select picture or texture fill.
- Simply use the image of your choice.
- Using this method you can adjust the transparency of the image, but not its ratio.
In the following section we will show you how to do the following:
- Insert an image while keeping the ratio.
- Keep the dimensions
- Keep the ratio of the image.
- Transparency available.
How to insert an image with transparency?
- Using GDI + APIs for the dimensions of the image.
- You can move the image, rotate it, change the dimensions of the available area. But it is not advisable to resize the image with the handles (and thus lose the ratio of the image).
- For the demo we have determined the surface area available with the top right of the button Changer Image:

- It is easy to directly enter the dimensions in the code In Module1, look for the RemplaceImage routine.
'Rectangle disponnible pour l'image, en points With Sheets("Image").CommandButton1 Dispo.W = (.Left + .Width) Dispo.H = .Top End With
- Replace these lines with
'Rectangle disponible pour l'image, en points Dispo.W = La largeur en point Dispo.H = La hauteur en point
CAUTION: These dimensions are not those of the image, depending on the ratio of the image file only one of the two will be effective.
Do you need more help with excel? Check out our forum!
Subject
Replies
Excel
- Excel png transparent
- Excel background image transparency
- Excel picture transparency
- Transfer data from one excel worksheet to another automatically > Guide
- How to change date format in excel > Guide
- Excel @ in formula [solved] > Forum - Excel
- How to change author name in excel > Guide
- Compare two worksheets and paste differences to another sheet - excel vba free download [solved] > Forum - Excel
- Fix arrows keys in Excel: Scroll lock, alternative method
- How to take screenshot in Excel: shortcut, sheet, cell
- How to apply a function to multiple sheets on Excel
- Convert numbers to words in Excel: without VBA, formula
- How many IF statements can you nest in Excel
- How to use Excel color cell if formula
- How to display multiple columns in a validation list
- How to use an IF statement to add 1 to total
- How to perform a partial cell match in Excel?
- How to run macro when data entered in a cell
- Check if a value exists in an array VBA
- Search and find using VBA in Excel
- VBA select case like: operator, string, statement
- What is the VBA code to select last sheet in workbook
- VBA Excel color codes: index number, list
- How to insert file path in excel: cell, sheet
- How to disable auto recover in Excel
- How to enable VBA in Excel: Mac, Office 365
- How combine IF function, SEARCH and ISERROR in Excel
- How to enter multiple lines in a single Excel cell
- How to insert GIF in Excel: 365, sheet, VBA
- How to count names in Excel: formula, using COUNTIF
- Open and convert an Excel file in Notepad
- Repeat rows in Excel: based on cell value, VBA
- How to automatically transfer data between sheets in Excel
- How to manipulate data in Excel: VBA
- How to copy a Macro into a blank cell
- Insert a hyperlink in Excel: with text, to another tab
- Recover Excel file: previous version
- Run macro on opening: worksheet, workbook
- How to transfer data from one Excel sheet to another?
- Most useful Excel formulas: for data analysis
- Recalculate Excel workbook before saving
- How to apply if function in Excel: with dates, with text
- Select the default number of processors in Excel
- Insert picture in Excel: cell, shortcut, using formula
- How to add sheet to workbook: VBA, Excel
- Unlock password protected Excel file: Macro
- Excel functions in French
- How to create a cascading combo box: Excel, VBA
- How to create calculator in Excel VBA
- Excel export data: from one sheet to another
- How to add a number of days to a date in Excel
- How to fill multiple Excel sheets from master sheet
- How to copy data to another workbook: using VBA
- Transfer Excel data from one sheet to another: VBA
- Excel VBA add command button programatically
- How to change a column to numeric in Excel?
- Mark sheet grade formula in Excel: template
- How to connect VB 6.0 with MS Access
- How to remove leading apostrophe in Excel
- How to create UserForm: in Excel, VBA
- Select empty cell in Excel: VBA
- Excel send value to another cell
- Using VBA to find last non empty row: in column, in table
- How to show or hide formula bar in Excel: VBA, shortcut
- How to change enter key function in Excel
- How to use Excel auto numbering formula
- Conditional formatting with dates: in Excel
- How to calculate VAT in Excel: formula
- Transfer a worksheet to another Excel workbook: without VBA
- Delete duplicates in Excel: column, formula
- Send email with attachment Excel: VBA, macros
- Compare two Excel sheets: and combine data
- Copy data from one Excel workbook to another
- Auto generate serial number in Excel: VBA, formula
- How to generate email notifications for Excel updates
- How to create a drop-down list in Excel
- Split a workbook into individual files in Excel
- How to insert blank rows using macros in Excel
- Run Macros in Excel: online, shortcuts, VBA
- How to clear formatting in Excel
- Insert an image into an Excel comment box
- Credit summation formula
- Create new sheet based on cell value: Excel, macro
- How to insert multiple rows in Excel with a macro?
- How to change Excel date format
- How to create a timer in Excel VBA
- How to use conditional formatting in Excel
- How to count occurrences of characters and numbers in Excel
- How to split text in columns in Excel
- Shortcuts to insert in Excel
- How to copy data to multiple worksheets in Excel
- Excel IF, AND, OR, and NOT functions
- Create a new workbook and copy data in Excel via a Macro
- Update dates in Excel spreadsheet: each year, formula
- How to change row color in Excel VBA based on value