I'm not sure what the 'following formats' are, but simply putting a $ in front of the letter will lock the column reference, and putting a $ in front of the number will lock the row reference. Putting a $ in front of both will allow you to keep the cell reference the same. For example:
A1 should be A$1$ in an equation to keep the reference as A1 for all 'filled down' equations.
A quick way to restore the arrow pointer after you have used it for drawing is to press the esc key. The esc key is <span>used for any of the different </span>functions<span>, as to interrupt or cancel the current process or running program, or to close a pop-up window.</span>
