Microsoft Office Tutorials and References
In Depth Information
Selecting multiple objects
Selecting multiple objects
In many cases, you may want to work with several AutoShapes at one time. Excel
provides several methods that enable you to select multiple objects on a worksheet
or chart.
Press Ctrl while you click the objects.
Click the Select Objects tool on the Drawing toolbar. The mouse pointer turns
into an arrow. Click and “lasso” the objects that you want to select. To return
to normal selection mode, press Esc or click the Select Objects tool again.
To select all objects on the worksheet, choose Edit
Go To (or press Ctrl+G)
to display the Go To dialog box. Click Special, choose the Objects option
button, and click OK. This method is particularly useful if you want to
delete all objects on a worksheet. When the objects are selected, press Del.
Moving objects
To move an object, select it and drag one of its borders. For more precise control,
use the arrow keys to move the selected object one pixel at a time.
Copying objects
You can use Excel’s standard Copy and Paste operations to copy graphic objects on
a worksheet or within a chart. Another alternative is to select one or more objects
and then press Ctrl while you drag in the worksheet.
To copy an object from the worksheet’s drawing layer into a chart, select the
object and choose Edit
Copy. Then activate your chart and choose Edit
Changing the stack order of objects
As you add objects to the drawing layer of a worksheet (or to a chart), you’ll find
that objects are “stacked” on top of each other in the order in which you add them.
New objects are stacked on top of older objects.
In some case, an object may be partially or completely hidden by an object
higher in the stack. You can change the order in this stack. Right-click the object
and select Order from the shortcut menu. This command leads to a submenu with
the following choices:
Bring to Front: Brings the object to the top of the stack.
Send to Back: Sends the object to the bottom of the stack.
Bring Forward: Brings the object one step higher toward the top of the
Send Backward: Sends the object one step lower toward the bottom of the
Search JabSto ::

Custom Search