When you draw a regular line using shapes, and you want to move one end of
the line to straighten it or move it around, you can move it back to being
straight or in small increments.
In Excel 2000 and 2003, when you used your mouse to grab and move the end of
the line, you could hit 'alt' at the same time and it would help you to move
the line in small increments. This does not work in Excel 2007. The end of
your line just jumps around.

Anyone able to help? Thanks.

Hmm. Hadn't noticed that before and don't know the answer to your question.

If you only want to make it perfectly horizontal then perhaps you should
delete the line and insert a new one, holding the Shift key down while you
draw.

If you hold the Shift key down, Excel will draw the line horizontally IF you
drag left or right first. It'll draw the line vertically if you drag up or
down first.

"Laurieg" wrote:

When you draw a regular line using shapes, and you want to move one end of
the line to straighten it or move it around, you can move it back to being
straight or in small increments.
In Excel 2000 and 2003, when you used your mouse to grab and move the end of
the line, you could hit 'alt' at the same time and it would help you to move
the line in small increments. This does not work in Excel 2007. The end of
your line just jumps around.

Anyone able to help? Thanks.