How to convert range of cells to image in Excel?
There are times when you want to present your data not as editable cells but as a static image—for example, when creating presentations, embedding in documents, or sharing via email. Fortunately, Excel allows you to convert any selected cell range into an image in just a few steps. This guide covers multiple methods to convert a cell range into an image.
Convert a range of cells to image with Copy as Picture feature
Convert a range of cells to image with Kutools for Excel
Convert a range of cells to image with VBA code
Convert a range of cells to image with Copy as Picture feature
Excel offers a built-in feature that allows users to copy selected cells as an image. Here's how to do it:
- Select the range of cells you want to convert to an image. And press "Ctrl + C" to copy it.
- Go to the "Home" tab on the Ribbon. Click "Copy" > "Copy as Picture". See screenshot:
- In the dialog box, specify the following options:
- As shown on screen: ensures the picture looks exactly like what’s visible.
- Picture: copies it as a static image.
- Click OK, then press "Ctrl + V" to paste the image into the worksheet.
- Then, right click the image and choose "Save as Picture". See screenshot:
- In the following window, specify a folder to save the picture, enter a name for it, and choose the desired picture format from the "Save as" type drop-down list. See screenshot:
- Click the "Save" button, and the selected cell range has been saved as the picture format in the specific folder.
Convert a range of cells to image with Kutools for Excel
If you frequently need to convert cell ranges into images, Kutools for Excel provides a more powerful and flexible solution. With its "Export Range as Graphic" feature, you can effortlessly export any selected range as a high-quality image in various formats such as PNG, JPG, GIF, or TIF.
After installing Kutools for Excel, please do with the following steps:
- Select the range of cells you want to convert to an image. Then, click "Kutools Plus" > "Import / Export" > "Export Range as Graphic".
- In the dialog box, please do the following operations:
- Specify a folder to locate the new image file;
- Select one picture format from the "Export format" section;
- Click OK button.
- In the following prompt box, enter a name for the image.
- Click OK to save the range as graphic.
Convert a range of cells to image with VBA code
For advanced users or those who want to automate the task, using VBA can be a powerful approach.
- Select the range of cells you want to convert to an image.
- Hold down the "ALT + F11" keys to open the "Microsoft Visual Basic for Applications" window.
- Click "Insert" > "Module", and paste the following code into the Module Window.
Sub SaveSelectedRangeAsImage() 'Updateby Extendoffice Dim rng As Range Dim chartObj As ChartObject Dim imgPath As Variant Dim fileName As String If TypeName(Selection) <> "Range" Then MsgBox "Please select a range before running the macro.", vbExclamation Exit Sub End If Set rng = Selection imgPath = Application.GetSaveAsFilename( _ InitialFileName:="RangeImage.png", _ FileFilter:="PNG Files (*.png), *.png", _ Title:="Save Image As") If imgPath = False Then Exit Sub rng.CopyPicture Appearance:=xlScreen, Format:=xlPicture Set chartObj = ActiveSheet.ChartObjects.Add(Left:=100, Top:=100, Width:=rng.Width, Height:=rng.Height) chartObj.Activate chartObj.Chart.Paste chartObj.Chart.Export fileName:=imgPath, FilterName:="PNG" chartObj.Delete MsgBox "Image saved to: " & imgPath, vbInformation End Sub
- Press F5 key to run this code, in the following window, specify a folder to put the image and enter a name for the image file, see screenshot:
- Click OK button, the selected range will be saved as an image file.
Conclusion
Converting Excel ranges to images is a handy technique that can save time and improve the way you share your data. Excel’s built-in Copy as Picture feature is perfect for quick, manual exports, while Kutools for Excel offers a more advanced and user-friendly option for batch processing and customization. For those comfortable with automation, using VBA code provides a flexible and scalable solution. Depending on your needs—simplicity, efficiency, or automation—one of these methods is sure to fit seamlessly into your workflow. If you're interested in exploring more Excel tips and tricks, our website offers thousands of tutorials to help you master Excel.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!