How to use sizing handles in Excel to resize objects

Size handles are used to resize objects in spreadsheet applications such as Excel and Google Sheets. These objects include clip art, clip art, text boxes, charts and graphs.

Remark † The instructions in this article apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Online, and Excel for Mac.

Contents
  1. Finding Calibration Buttons
  2. Activate the calibration button
  3. Using Calibration Buttons
  4. Dimensional Buttons vs Fill Button

Finding Calibration Buttons

Depending on the object, dimensional handles can have different shapes. Dimensional markers can be represented as small circles or squares.

Activate the calibration button

Dimensional markings are usually not visible on the object. They only appear when the object is selected by clicking it once with the mouse or by using the tab key on the keyboard. Once an object is selected, it is outlined with a thin border. The calibration buttons are part of the bezel.

There are eight sizing handles per object, located on the four corners of the border and in the center of each side. Allows you to resize an object in any direction.

Using Calibration Buttons

To resize an image or chart, drag the resize handle until the image is the size you want. Here’s how:

  1. Move your mouse over one of the glue handles. The mouse pointer changes to a double-headed arrow.

  2. Drag the handle to make the object larger or smaller.

Corner handles allow you to resize an object in two directions at once: length and width. Measures along the sides of an object only change in one direction at a time.

Dimensional Buttons vs Fill Button

Size descriptions should not be confused with: Fill handle in Excel. The fill handle is used to add or copy data and formulas in the cells of a worksheet.

Leave a Reply

Your email address will not be published.