Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Tool Bar | Excel Discussion (Misc queries) | |||
Why would excel tool bar options be grayed out? | Excel Discussion (Misc queries) | |||
How do I set Save Options? | Excel Discussion (Misc queries) | |||
Free Data Process/Query Tool | New Users to Excel | |||
Excel Tool Bar Gone | Excel Discussion (Misc queries) |