tool: options disabled

[Sara]

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?

 

[Bob Phillips]

Goto Tools>Options>Edit and make sure the Allow drag and drop box is
checked.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)