bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Graphics > Sending Drawing Objects to the Back or Front

Sending Drawing Objects to the Back or Front

Summary: Objects played on the drawing layer can be arranged in front of or behind each other. Knowing how to change this arrangement can come in real handy when you are trying to get just the right look for your drawing. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

When you create objects in Excel using the Drawing toolbar, each object is drawn on its own layer. This means all objects are independent and can be moved on top of other objects. However, there may be times when you actually want an object to be under another object. You can do this by following these steps:

  1. Select the pointer tool (the arrow) from the Drawing toolbar.
  2. Using the mouse, point to the shape you want to send to the back, and click on it. Small square boxes called handles appear around the perimeter of the shape.
  3. Choose Order from the Draw menu on the toolbar. Excel displays a set of ordering commands.
  4. Choose the Send to Back option.

You can do the same sort of arrangement by choosing Bring to Front instead of Send to Back. Excel will move an item which may be behind others so that it overlays the others.

Tip #2199 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time! You can have this tip (and several hundred just like it) in the ExcelTips annual archives. Imagine having over 400 tips available at your fingertips, in each annual volume.

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)