All of a sudden, I can no longer use my mouse to drag content or formula to
other cells in the same spreadsheet.

The pointer remains as a solid cross sign even if I point the corner of the
selected range.

This also happen to page break. The solid cross no longer turn into a two
sided pointers. As a result, I cannot move the page break with my mouse.

Any suggestion to resolve this issue.

Brian

Brian,

Sounds as though Tools - Options - Edit tab - "Allow cell drag and drop"
isn't checked.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Brian" wrote in message
...
All of a sudden, I can no longer use my mouse to drag content or formula
to
other cells in the same spreadsheet.

The pointer remains as a solid cross sign even if I point the corner of
the
selected range.

This also happen to page break. The solid cross no longer turn into a two
sided pointers. As a result, I cannot move the page break with my mouse.

Any suggestion to resolve this issue.

Brian

Brian

ToolsOptionsEdit. Check "allow cell drag and drop".


Gord Dibben Excel MVP

On Mon, 14 Feb 2005 15:29:04 -0800, "Brian"
wrote:

All of a sudden, I can no longer use my mouse to drag content or formula to
other cells in the same spreadsheet.

The pointer remains as a solid cross sign even if I point the corner of the
selected range.

This also happen to page break. The solid cross no longer turn into a two
sided pointers. As a result, I cannot move the page break with my mouse.

Any suggestion to resolve this issue.

Brian