Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Pictures & Graphics > AutoShapes Formatting< Previous | Next > 

 

Formatting your AutoShapes

 
 

AutoShapes basically include everything that can be inserted from the Drawing toolbar except pictures and clipart.

 
   

 

Format AutoShape Dialog Box

 
 

Depending on the type of autoshape that is selected will depend on the specific formatting options available.

 
 

You can display the Format AutoShape dialog box by selecting any autoshape object by using the shortcut menu.

 
 

Screen shots of all the possible tabs that can be displayed are shown below:

 

 

Properties Tab

 
   
 

This applies to any cells that have a border between the upper left and lower right corners of the autoshape.

 
 

For example all the shaded cells will be affected with the following two autoshapes

 
   
 

Move and size with cells - Changing the size of the cells underneath the autoshape will change the size of the autoshape.

 
 

Move but don't size with cells - Changing the size of cells (or inserting/deleting rows and columns) will move the autoshape without resizing it.

 
 

Don't move or size with cells - Changing the size of cells (or inserting/deleting rows and columns) will not affect the autoshape.

 

 

Color and Lines Tab

 
   

 

Alignment Tab

 
   

 

Font Tab

 
   

 

Margins Tab

 
   

 

Size Tab

 
   

 

Protection Tab

 
   

 

Web Tab

 
   


 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >