Friday, January 21, 2011

How to Draw a Line in Excel 2007


Straight Lines
1. Launch Excel 2007. Open an existing document if you do not need to start with a blank worksheet.
2. Click 'Insert' on the ribbon and select 'Shapes.'
3. Click on a line style from the 'Lines' section of the drop-down menu. A thin, black cross will appear on your worksheet.
4. Click and drag the line down or across to create the line. Hold down 'Shift' while dragging if you want a line with exactly a zero-, 45- or 90-degree angle. The line will appear with a circle on each end.
5. Click a circle on the end of the line and drag it out to extend the line. Drag the circle up or down to change the slope of the line.
6. Click on the line and select a different color or thickness from the Shape Styles menu to change the look of the line.
Curved Lines
7. Click the 'Insert' tab on the ribbon and select 'Shapes.'
8. Select a curved line style from the 'Lines' group in the menu. You can select a curve, a free-form shape or a scribble.
9. Click and drag the thin, black cross around the worksheet to create a curved or free-form line. If you select a curve or a free-form shape, you will need to click each time you want to define a peak and valley on your curve or bends in your free-form shape. If you select a scribble, you can simply let go of the mouse button once you are done drawing the line.
10. Double-click when you are done defining the line. Excel will outline your shape with a box with points, allowing you to further manipulate other aspects of the shape.

Blogger news