Skip to main content

How to convert range of cells to image in Excel?

Author: Kelly Last Modified: 2025-04-14

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:
    click Copy as Picture feature
  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.
      specify the options in the dialog box
  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:
    right click and choose Save as Picture
  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:
    specify the folder and file name
  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.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

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".
    click Export Range as Graphic feature of kutools
  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.
      specify the optiona in the dialog box
  3. In the following prompt box, enter a name for the image.
    specify a name for the file
  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:
    specify a name for the file
  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.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

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!