Changing Line Color in a Drawing Object: MS Excel

Lines are used for all graphics in MS Excel. Lines are typically used to outline the shape, but you can also use them for arrows and for drawing directly on your worksheet.

Excel allows you to specify the color or pattern that should be used for your lines. To change the line color used in an object, follow the steps below for a version prior to 2007:

1. Make sure the Drawing toolbar is displayed.
    
2. Click once on the object whose line color you want to change to select it.
    
3. Click on the Line Color tool o n the Drawing toolbar. The color of the lines in the object are changed to the color used in the bar at the bottom of the Line Color tool.
    
4. To use a different color, click on the down-arrow to the right of the tool and choose a color of your choice.

There is no Drawing toolbar in Excel 2007, so you will have to follow the steps below to accomplish the same result:

1. Click once on the object whose color you want to change to select it.
    
2. Make sure that the format tab is selected on the ribbon.
    
3. In the Shape Styles group on the ribbon, click the down-arrow next to the Shape Outline tool.
    
4. Choose a color from those offered in the droop-down area.

That's all there is to it, so go ahead and experiment with it!

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!