I use spreadsheets to solve complex structural engineering problems and so I
need to draw shapes and lines to show what I am doing.
When I go to print the worksheet the lines I have drawn shift on me and mess
up the entire worksheet. Is there a way to shift all the lines to where they
were originally drawn. Is there a way to lock them into position?

On printing, the autoshape should be pointing right at the highest value on the dark blue series. At 100% zoom, everything looks fine.

Hi,

Excel is probably making (small?) adjustments to the page to fit for printing.

Would suggest you try selecting ALL objects and the form a Group.

This may be just the first step.

OR

Is Powerpoint a better application for your purpose??

Educo