Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close

Manipulate objects

You can resize, move, rotate and arrange autoshapes, images and charts inserted into your worksheet.

Note: the list of keyboard shortcuts that can be used when working with objects is available here.

Resize objects

To change the autoshape/image/chart size, drag small squares Square icon situated on the object edges. To maintain the original proportions of the selected object while resizing, hold down the Shift key and drag one of the corner icons.

Note: to resize the inserted chart or image you can also use the right sidebar that will be activated once you select the necessary object. To open it, click the Chart settings Chart settings icon or the Image settings Image settings icon icon to the right.

Maintaining proportions

Move objects

To alter the autoshape/image/chart position, use the Arrow icon that appears after hovering your mouse cursor over the object. Drag the object to the necessary position without releasing the mouse button. To move the object by the one-pixel increments, hold down the Ctrl key and use the keybord arrows. To move the object strictly horizontally/vertically and prevent it from moving in a perpendicular direction, hold down the Shift key when dragging.

Rotate objects

To manually rotate the autoshape/image, hover the mouse cursor over the rotation handle Rotation Handle and drag it clockwise or counterclockwise. To constrain the rotation angle to 15 degree increments, hold down the Shift key while rotating.

To rotate a shape or image by 90 degrees counterclockwise/clockwise or flip the object horizontally/vertically you can use the Rotation section of the right sidebar that will be activated once you select the necessary object. To open it, click the Shape settings Shape settings icon or the Image settings Image settings icon icon to the right. Click one of the buttons:

  • Rotate counterclockwise icon to rotate the object by 90 degrees counterclockwise
  • Rotate clockwise icon to rotate the object by 90 degrees clockwise
  • Flip horizontally icon to flip the object horizontally (left to right)
  • Flip vertically icon to flip the object vertically (upside down)

It's also possible to right-click the image or shape, choose the Rotate option from the contextual menu and then use one of the available rotation options.

To rotate a shape or image by an exactly specified angle, click the Show advanced settings link at the right sidebar and use the Rotation tab of the Advanced Settings window. Specify the necessary value measured in degrees in the Angle field and click OK.

Reshape autoshapes

When modifying some shapes, for example Figured arrows or Callouts, the yellow diamond-shaped Yellow diamond icon icon is also available. It allows to adjust some aspects of the shape, for example, the length of the head of an arrow.

Reshaping autoshape

Align objects

To align two or more selected objects in relation to each other, hold down the Ctrl key while selecting the objects with the mouse, then click the Align icon Align icon at the Layout tab of the top toolbar and select the necessary alignment type from the list:

  • Align Left Align Left icon - to align objects in relation to each other by the left edge of the leftmost object,
  • Align Center Align Center icon - to align objects in relation to each other by their centers,
  • Align Right Align Right icon - to align objects in relation to each other by the right edge of the rightmost object,
  • Align Top Align Top icon - to align objects in relation to each other by the top edge of the topmost object,
  • Align Middle Align Middle icon - to align objects in relation to each other by their middles,
  • Align Bottom Align Bottom icon - to align objects in relation to each other by the bottom edge of the bottommost object.

Alternatively, you can right-click the selected objects, choose the Align option from the contextual menu and then use one of the available alignment options.

Note: the alignment options are disabled if you select less than two objects.

Distribute objects

To distribute three or more selected objects horizontally or vertically between two outermost selected objects so that the equal distance appears between them, click the Align icon Align icon at the Layout tab of the top toolbar and select the necessary distribution type from the list:

  • Distribute Horizontally Distribute Horizontally icon - to distribute objects evenly between the leftmost and rightmost selected objects.
  • Distribute Vertically Distribute Vertically icon - to distribute objects evenly between the topmost and bottommost selected objects.

Alternatively, you can right-click the selected objects, choose the Align option from the contextual menu and then use one of the available distribution options.

Note: the distribution options are disabled if you select less than three objects.

Group several objects

To manipulate several objects at once, you can group them. Hold down the Ctrl key while selecting the objects with the mouse, then click the arrow next to the Group icon Group icon at the Layout tab of the top toolbar and select the necessary option from the list:

  • Group Group icon - to join several objects into a group so that they can be simultaneously rotated, moved, resized, aligned, arranged, copied, pasted, formatted like a single object.
  • Ungroup Ungroup icon - to ungroup the selected group of the previously joined objects.

Alternatively, you can right-click the selected objects, choose the Arrange option from the contextual menu and then use the Group or Ungroup option.

Note: the Group option is disabled if you select less than two objects. The Ungroup option is available only when a group of the previously joined objects is selected.

Group several objects

Arrange several objects

To arrange the selected object or several objects (e.g. to change their order when several objects overlap each other), you can use the Bring Forward icon Bring Forward and Send Backward icon Send Backward icons at the Layout tab of the top toolbar and select the necessary arrangement type from the list.

To move the selected object(s) forward, click the arrow next to the Bring Forward icon Bring Forward icon at the Layout tab of the top toolbar and select the necessary arrangement type from the list:

  • Bring To Foreground Bring To Foreground icon - to move the object(s) in front of all other objects,
  • Bring Forward Bring Forward icon - to move the selected object(s) by one level forward as related to other objects.

To move the selected object(s) backward, click the arrow next to the Send Backward icon Send Backward icon at the Layout tab of the top toolbar and select the necessary arrangement type from the list:

  • Send To Background Send To Background icon - to move the object(s) behind all other objects,
  • Send Backward Send Backward icon - to move the selected object(s) by one level backward as related to other objects.

Alternatively, you can right-click the selected object(s), choose the Arrange option from the contextual menu and then use one of the available arrangement options.

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action