Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.
The Arrange section in Excel allows you to bring objects forward and backward (in front of or behind other objects), hide/show objects, align multiple selected objects, group and rotate objects.
When you have multiple objects in a document, you can utilize the Bring Forward function so that your selected object is hidden by fewer objects. For example, in the image below, we have a lightning bolt on bottom, star in middle and the smiley face on top.
To bring the lightning bolt forward by one image, select the Bring Forward drop-down menu and then select Bring Forward. The lightning bolt will now be positioned in the middle (between the star and smiley face). If you would have selected the other option in the drop-down menu, Bring to Front, the lightning bolt would be positioned in front or on top of the star and smiley face.
Similarly, the Send Backward option will do the same, only the objects will move backwards – being hidden by the objects in front of them.
Another way to arrange your objects is by utilizing the Selection Pane. To make the pane visible, select the Selection Pane button in the Arrange section of the Page Layout tab. It will appear on the right side of your document and will look similar to the image to the right.
As you can see, we have each object listed in the Selection Pane: Smiley Face 3, 5-Point Star 4 and Lightning Bolt 2.
The buttons at the bottom of the pane allow you to quickly Show All or Hide All of your objects.
You can remove an individual object by selecting the icon next to it that looks like an eye. Select the icon again for the object to reappear.
Select the Selection Pane button again if you would like to clear it from your document.
The Align function in the Arrange section allows you to align your objects to the left, center, right, top, middle, bottom, distribute horizontally or distribute vertically.
First, select all of your objects by holding down the shift key and then clicking on each object. Then select the Align drop-down menu and select from the various alignment options, as shown in the image to the left.
We chose the bottom alignment (as shown in the image to the right).
You can see how each object lines up at the bottom.
To rotate or flip your object, first select your object and then click on the Rotate button in the Arrange section.
As shown in the image to the left, you can rotate your object right or left and flip your object vertical or horizontal.
This concludes the Page Layout tab tutorial.
Click next to continue to the Excel 2010 Formulas Tab tutorial.