Microsoft Office Tutorials and References
In Depth Information
Snap To Shape Turns on the Snap To Grid command when you choose it, activating
its functionality. It adds to the spreadsheet grid virtual gridlines tangent to the edges
of any existing objects, making it easy to align objects to the grid or to one another.
If you turn off the Snap To Grid command, the Snap To Shape command is turned off
as well. The Snap To Shape command is also a toggle.
The Align and Distribute commands Arrange the selected objects relative to each
other. These buttons are available only when you select two or more objects.
Align Left/Right/Top/Bottom Lines up the edges of all selected objects
with the corresponding edge of the leftmost, rightmost, top, or bottom object
Align Center Lines up the centers of objects along a vertical axis, and finds
the average common centerline of all selected objects.
Align Middle Lines up the centers of objects along a horizontal axis, and
finds the average common centerline of all selected objects.
Distribute Horizontally/Vertically Calculates the total amount of space
between the selected objects and divides the space as equally as possible
among them. The first and last objects (leftmost and rightmost or top and
bottom) do not move—all the objects in between are adjusted as necessary.
You can use the arrow keys on your keyboard to nudge selected objects 1 pixel at a
time. If the Snap To Grid command is turned on, pressing an arrow key moves the
selected object to the next gridline in that direction.
Objects are ordinarily prevented from being selected, moved, formatted, or sized when you
apply protection to a worksheet (Review tab, Protect Sheet). You can change this before
applying sheet protection. To do so, right-click the object, click the Format Shape (or
Format Picture) command to display the Format Shape task pane, click the Size & Properties
icon (the four-headed arrow), and then select or clear the Locked check box in the
Properties category. You can also select the Lock Text check box in the Properties category, which
is available only when you select a text-capable object, to protect an object’s text contents.
Newly drawn objects are assigned Locked status. Remember, to activate worksheet security
and protection, you must also click Protect Sheet on the Review tab. For more information
about protection, see “Protecting worksheets” in Chapter 6, “How to work a worksheet.”