PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO ARRANGE, ALIGN AND ROTATE SHAPE OBJECTS IN EXCEL?

INTRODUCTION

When we create reports, we often make use of Shapes, charts etc. which we sometimes call as objects.

An object is a self contained entity which has many methods and properties which can be set by the user to change the behavior of the object. Simply speaking, the cells, rows, charts, shapes etc. are all objects.

The objects which we refer in this article are specifically the CHARTS and SHAPES etc. which are graphics portion of the EXCEL. Many times when we have more than one such graphical object we come across the need to put the  object in the sequence, throwing them back, bringing them to the front, rotating etc.which can be easily done with these options.

BUTTON LOCATION TO ARRANGE SHAPE OBJECTS IN EXCEL

The options to arrange the shape and chart objects are found under the FORMAT TAB which appears when we select any shape object or chart object.

The options are found on the right side of the tab tools.

 

STEPS TO ARRANGE SHAPE OBJECTS IN EXCEL

Suppose we have inserted any objects, then it may be needed to put some specific object behind the other as shown in the pic. The rectangular figure is covering the circle. Now if we need to put the rectangle behind the circle, follow the steps

STEPS TO SEND BACK AN OBJECT

 Look at the picture below. The rectangle shape is overlapping the circle.

We want to send it back.

shapes in excel
Current position of the Shapes. The rectangle overlaps the ellipse.

STEPS:

  • Double Click the rectangle i.e. the shape which we want to send back. It’ll select the rectangle as well as open the option for arranging the objects.
  • We can see the SEND TO BACK option in the picture below.
  • Now, if we simply want to SEND TO BACK which means sending the shape or object to the bottom, then click it or click the lower portion of the button and click SEND BACKWARD if we just want the object go one step down.
Sending the shape back of other shapes
Options under SEND IT BACK button
  • REFER PICTURE ABOVE:
  • Now, if we simply want to SEND TO BACK which means sending the shape or object to the bottom, then click it or click the lower portion of the button and click SEND BACKWARD if we just want the object go one step down.
send the shape behind other shape
Rectangle sent to back

STEPS TO ALIGN OBJECTS IN EXCEL

STEPS TO ALIGN THE OBJECT

  • The alignment is done between more than one object. So we need to select all the object which we want to align.
  • Click the first object.
  • Press control and click the other object.
  • Repeat the process until all the objects are selected which we want to align.
  • Now go to Align option and choose the one we want.
  • As soon as we select any object, a temporary tab named FORMAT opens up which contains all the options associated with the shapes such as designing etc. On the same tab we’ll get our ARRANGE SET of options on the right side of the tab

 

The details of the options are given below.

ALIGN THE OBJECT TOP, MIDDLE AND BOTTOM

ALIGN , as the word itself means to put in order or in some even fashion. We get a number of options. Such as ALIGN  TOP, MIDDLE, BOTTOM,LEFT, CENTER, RIGHT, DISTRIBUTE HORIZONTALLY and DISTRIBUTE VERTICALLY.

REFER PICTURE BELOW:

ALIGN TOP Align the center of all the selected objects in a line.

ALIGN  MIDDLE Align the center of all the selected objects in a line.

 ALIGN BOTTOM Align the center of all the selected objects in a line.

Align top middle and bottom in excel
THE STEPS TO ALIGN THE OBJECTS IN TOP MIDDLE AND BOTTOM POSITION

ALIGN THE OBJECT LEFT, CENTER AND RIGHT

REFER PICTURE: BELOW

ALIGN LEFT            Align the left of all the selected objects in a line.

ALIGN CENTER       Align the center of all the selected objects in a line.

 ALIGN RIGHT        Align the center of all the selected objects in a line.

Align objects to left center and right in excel
THE STEPS TO ALIGN THE OBJECTS IN LEFT , CENTER AND RIGHT

DISTRIBUTE THE OBJECTS HORIZONTALLY AND VERTICALLY

DISTRIBUTE HORIZONTALLY Distribute all the objects having equal distances in between horizontally. Distribution will take place as per the center of the shapes. In the example shown the size of the shapes is almost same but the process can be applied to any type of shape and of any size. The center of the shapes will be divided horizontally. Please always take care that it doesn’t mean that shapes won’t overlap each other.

DISTRIBUTE VERTICALLY. Distribute all the objects having equal distances in between vertically. The distribution will take place with respect to the center of the shapes. Similar to the horizontal distribution , it is to be noted that any type of shapes can be put for the distribution but the calculation of the distances will be on the basis of center of the shapes. The shapes can even overlap each other while distributing themselves.

distribute objects horizontally and vertically in excel
THE STEPS TO DISTRIBUTE THE OBJECTS HORIZONTALLY AND VERTICALLY

SNAP TO GRID, SHAPES AND HIDE GRIDLINES

 

Three more options are there.

These additional align options give us the facility to snap or stick our objects[charts, shapes etc.] to the grid or shape. It simply makes our objects sticky to make it more uniform and it starts sticking to the grid lines or shapes.

SNAP TO GRID: The options are not for any specific object but will be applicable to the sheet. The objects will become sticky towards the grid and would try to stick any of their edge or end portion to the grid. It is just a helping feature and doesn’t mean that the shapes would stick necessarily.

SNAP TO SHAPE: In the previous option, the shapes starts sticking to the grid  and in this case the shapes starts sticking to the other SHAPES.

VIEW GRID LINES: Make the grid lines visible if selected and remove them if deselected.

Snapping the object to the grid or shape in excel
SNAP TO GRID AND SNAP TO SHAPE DEMONSTRATION

STEPS TO ROTATE OBJECTS IN EXCEL

STEPS:

  • Select the object.(Shape)
  • Double click it. The options will open. The name of the temporary tab is FORMAT. Click it , if not opened there directly.
  • Click on the ROTATE BUTTON and rotate as per requirement.
  • If any customized rotation is needed, go to MORE ROTATION OPTION.
  • We can rotate it to any degree as per need.
  • The complete demonstration is given in the following animation.
ROTATE SHAPE OBJECT IN EXCEL
ROTATING SHAPE OBJECT IN EXCEL

OTHER WAYS TO REACH THIS ARTICLE

  • OBJECTS IN EXCEL, HANDLE OBJECTS IN EXCEL, PUT SHAPES IN EXCEL, ROTATE OBJECTS IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: