tool: options disabled
 

When trying to drag a formula to the cell next to the original, no drag arrow
is available. I used to be able to copy formulas by moving my mouse over the
bottom right hand corner of a cell and dragging into adjacent cells. I can no
longer do this. As well I can't change the page breaks in 'page break
preview' It was suggested to change my options in the Tools menu. However,
Options... is disabled and I can't get into it to change anything. I don't
have this problem with any other Office application just Excel. Any ideas of
how to fix this?

options disabled
 

Goto ToolsOptionsEdit and make sure the Allow drag and drop box is
checked.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sara" wrote in message
...
When trying to drag a formula to the cell next to the original, no drag
arrow
is available. I used to be able to copy formulas by moving my mouse over
the
bottom right hand corner of a cell and dragging into adjacent cells. I can
no
longer do this. As well I can't change the page breaks in 'page break
preview' It was suggested to change my options in the Tools menu. However,
Options... is disabled and I can't get into it to change anything. I don't
have this problem with any other Office application just Excel. Any ideas
of
how to fix this?