Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Excel allows you to create drawing objects you can use in your worksheets. These objects (such as an oval, rectangle, line, or AutoShape) are positioned on what is termed the "drawing layer," which is separate and distinct from the values or formulas in the cells of your worksheet. You generally create such objects by using the tools on the Drawing toolbar. (Display the Drawing toolbar by clicking on the Drawing tool on the Standard toolbar.)
On the left side of the Drawing toolbar are several tools that are used to create basic shapes. The line, arrow, rectangle, and oval tools are easily identifiable. In addition, you can use the AutoShapes tool to display a menu of more than 125 different symbols, banners, and callouts. Follow these steps to place a drawing object in your worksheet:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2197) applies to Microsoft Excel versions: 97 2000 2002 2003
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.