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:

1. Select the range of cells you want to convert to an image. And press "Ctrl + C" to copy it.
2. Go to the "Home" tab on the Ribbon. Click "Copy" > "Copy as Picture". See screenshot:
   
3. 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.
     
4. Click OK, then press "Ctrl + V" to paste the image into the worksheet.
5. Then, right click the image and choose "Save as Picture". See screenshot:
   
6. 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:
   
7. 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:

1. Select the range of cells you want to convert to an image. Then, click "Kutools Plus" > "Import / Export" > "Export Range as Graphic".
   
2. 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.
     
3. In the following prompt box, enter a name for the image.
   
4. 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.

1. Select the range of cells you want to convert to an image.
2. Hold down the "ALT + F11" keys to open the "Microsoft Visual Basic for Applications" window.
3. 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
   

4. 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:
   
5. 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.