How to resize all charts or pictures in Excel quickly?
Are you struggling to manage a cluttered Excel worksheet filled with charts and pictures of various sizes? Whether you're preparing for a presentation or simply aiming to tidy up your data, uniformity can make a significant difference. This tutorial will guide you through the simple steps to resize all your charts and pictures to the same dimensions, quickly transforming your worksheet into a more organized and visually appealing space.
Resize all charts at once
To uniformly resize all charts in the active worksheet, follow these steps:
Step 1: Select all charts in active worksheet.
You can do this by holding down the Ctrl key and clicking each chart.
Alternatively, use the following VB macro to quickly select all charts:
Public Sub SelectAllCharts()
'Updated by Extendoffice 2025/7/15
ActiveSheet.ChartObjects.Select
End Sub
Step 2: With the charts selected, the Drawing Tools will activate on the Ribbon. Navigate to the Format tab under the Drawing Tools.
Step 3: In the Size group, enter the desired height and width for the charts. See the following screenshot:
After these steps, all selected charts in the active worksheet will be resized to the same dimensions simultaneously.
Note: This method also applies to resizing pictures. To resize all pictures, use the Size group under Format tab in Picture Tools.
Resize all pictures at once
To resize all pictures in the active worksheet efficiently, follow these steps:
Step 1: Select all pictures in active worksheet.
The following VB macro can help you select all pictures in active worksheet quickly.
Public Sub SelectAllPics()
'Updated by Extendoffice 2025/7/15
ActiveSheet.Pictures.Select
End Sub
Step 2: Right-click on any selected picture and choose Format Object from the context menu.
Step 3: In the Format Pictures dialog box that appears, select the Size category from the left sidebar.
Step 4: Enter the desired height and width in the Size section. See the following screenshot:
Step 4: Click OK to apply the changes. All selected pictures will now be resized to the specified dimensions simultaneously.
By following these two methods, you can easily standardize the size of charts and pictures in your worksheet, enhancing the uniformity and professionalism of your document.
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!
