How to convert cell range to image in Excel?
While Microsoft Excel doesn't offer a direct way to export ranges as images, you can achieve this with the help of additional tools like the Paint application in Windows. This article will guide you through the steps to easily convert Excel ranges into images, enhancing your ability to share and present your data visually.
Convert cells range to image with Copy as Picture command
Convert cells range to image with Kutools for Excel
Convert cells range to image with Copy as Picture command
In Microsoft Excel, we can copy a range as a picture, but can't export it as an individual image. Here I will guide you to convert the Excel range to an image with the Copy as Picture command of Excel and Paint tool in Windows.
1. Select a range that you need to export as a picture.
2. Click Home > Copy > Copy as Picture, and in the Copy Picture prompt box, select the options as follows and click OK.
![]() | ![]() | ![]() |
3. Then open the Paint tool in Windows by clicking Start > All programs > Accessories > Paint. See screenshot:
4. Paste the copied picture in the Paint tool and save it. In the Save As dialog box, specify a folder you want to put the picture, enter the name of the picture, then choose the picture type you need from the Save as type drop-down list, See screenshot:
5. Click the Save button, and the selected cell range has been saved as the picture format in the specific folder.
- The Copy as Picture command cannot be used on multiple selections.
- If you want to copy the selection of Excel to Word, PowerPoint, or other programs, you can paste it to them directly after Step 2.
Convert cells range to image with Kutools for Excel
If you have Kutools for Excel installed, you can export cell range as images easily and quickly.
After installing Kutools for Excel, please do as follows:
1. Highlight the range that you want to export as a picture.
2. Click Kutools Plus > Import / Export > Export Range as Graphic, see screenshot:
3. In the Export Range as Graphic dialog box, select the graphic format you need, such as GIF, JPEG, TIF, or PNG. Then click the Specify Filename button. see screenshot:
4. In the popping-up dialog box, specify the directory and name for the picture, see screenshot:
5. Click Save button to save the graphic.
- This function is applied to a single range, not multiple selected ranges. Click Export Range as Graphic to know more.
- The Kutools for Excel's Export Range as Graphic tool can help us quickly convert a range (and the graphic objects displayed in the range) to an image in GIF, JPEG, TIF or PNG format.
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!
![Screen Shot of Excel (with Office Tab installed)](http://cdn.extendoffice.com/images/stories/kte-module/officetab-bottom-02.gif)
![Malcolm](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Chathura](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![Richard Bethell](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)
![surender rawat](http://cdn.extendoffice.com/media/com_easydiscuss/images/default_avatar.png)