How to resize all charts or pictures in Excel quickly?

If you work with Excel files that include multiple charts or images, you’ve probably seen how mismatched sizes can clutter your worksheet, complicate interpretation, and throw off alignment in printouts or dashboards. By standardizing every chart and picture—whether via built-in sizing tools or a simple VBA macro—you’ll instantly create a clean, cohesive layout that highlights your data and looks professional, whether you’re preparing for a meeting, sharing reports, or just keeping your own workspace organized. This tutorial provides practical, easy-to-follow steps—using built-in Excel features and VBA macros—to quickly and uniformly resize all charts or pictures at once.

Resize all charts at once

Resize all pictures at once

Resize all charts at once

When your worksheet includes several charts—such as bar graphs, line charts, or pie charts—each with different dimensions, it can be challenging to present your data in a cohesive way. To ensure that all charts appear uniform, follow these detailed instructions:

Step1: Select all charts in active worksheet

Select all charts in the active worksheet at once, which is essential if you want to make changes to all of them simultaneously. Manually clicking each chart while holding down the Ctrl key works, but it can be time-consuming, especially in large worksheets. For increased efficiency, you can use a simple VBA macro to automatically select all chart objects at once. To use the VBA macro:

1. Press Alt + F11 to open the VBA editor.
2. In the VBA window, click Insert > Module.
3. Copy and paste the following code into the module:

Public Sub SelectAllCharts()
'Updated by Extendoffice 2025/7/15
ActiveSheet.ChartObjects.Select
End Sub 

4. After adding the macro, press F5 or click the Run button to select all the charts automatically in your active worksheet.

Step 2: Set size for the selected charts

1. Once all charts are selected, the Drawing Tools, also known as Chart Tools (depending on your Excel version), will appear in the Ribbon, typically under a highlighted Format tab.
2. In the Size group, enter the desired height and width for the charts. For example, if you want every chart to be 5 cm high and 8 cm wide, input those values directly. Units can be adjusted as needed—Excel will recognize measurements in centimeters, inches, or pixels depending on your regional settings.
   

Result: All selected charts will instantly adopt the set size, neatly aligning your worksheet and improving visual uniformity:

Unlock Excel Magic with Kutools AI

• Smart Execution: Perform cell operations, analyze data, and create charts—all driven by simple commands.
• Custom Formulas: Generate tailored formulas to streamline your workflows.
• VBA Coding: Write and implement VBA code effortlessly.
• Formula Interpretation: Understand complex formulas with ease.
• Text Translation: Break language barriers within your spreadsheets.

Enhance your Excel capabilities with AI-powered tools. Download Now and experience efficiency like never before!

Resize all pictures at once

Pictures in Excel serve many purposes such as company logos, icons, and illustrations to support your data. When pictures of various sizes are scattered throughout a worksheet, it can lead to a disorganized appearance and alignment issues. Instead of resizing pictures one by one, you can adjust all images to your preferred size in one efficient process:

Step1: Select all pictures in active worksheet

First, select all pictures in the active worksheet. This can be done manually by holding the Ctrl key and clicking each picture. However, for greater speed and accuracy, use this VBA macro to select all pictures at once:

1. Press Alt + F11 to open the VBA editor.
2. Click Insert > Module to add a new module.
3. Copy and paste the code below into the module window:

Public Sub SelectAllPics()
'Updated by Extendoffice 2025/7/15
ActiveSheet.Pictures.Select
End Sub

4. Run the macro by pressing F5 or choosing Run. All pictures in the current worksheet will be selected at once, ensuring none are missed, even if some are layered or partially hidden.

Step 2: Set size for the selected pictures

1. With all pictures selected, right-click any picture among those selected and choose Format Object from the context menu. Please note that on some versions of Excel or with some images, the menu might instead read Format Picture.
   
2. In the Format Picture dialog box that opens, click the Size option from the sidebar. Here, carefully enter your desired width and height values. Make sure the aspect ratio lock is disabled if you want to specify both dimensions exactly; otherwise, Excel will keep the proportions fixed, adjusting one dimension automatically as you change the other.
   
3. Check over your entries before clicking OK, as any mistaken value (such as swapping width and height or entering excessively large sizes) can distort your pictures. After clicking OK, all selected pictures will instantly update to the specified size, giving your worksheet a consistent look that aids both readability and professional appearance.

This approach is especially useful when preparing reports containing multiple images or when arranging visual materials for dashboards. If you notice that some images are not resizing, ensure they are not grouped or set as backgrounds, as these may require special treatment.

By applying these methods for both charts and pictures, you can quickly standardize their dimensions, creating organized and visually appealing worksheets. If you frequently perform such formatting tasks, consider saving these VBA macros for repeated use. For complex scenarios, such as resizing objects across multiple sheets or only resizing selected image types, custom VBA solutions can be further tailored.