page break issue, etc.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C.S.Harris - 10 Mar 2007 14:56 GMT

My excel has suddenly stopped allowing me to adjust page breaks. Also, When I
have something in, say cell a1, and I want the same thing in a2, usually, I
can put in one or two letters and it will bring down the info automatically.
Now it doesn't.
Any suggestions? Is this a setting that can be turned on or off?

Reply to this Message

Gord Dibben - 10 Mar 2007 16:49 GMT

For the page break issue................

Make sure Tools>Options>Edit "allow cell drag and drop" is checked.

For the autocomplete issue...............

Make sure Tools>Options>Edit "enable autocomplete for cell values" is checked.

Gord Dibben MS Excel MVP

>My excel has suddenly stopped allowing me to adjust page breaks. Also, When I
>have something in, say cell a1, and I want the same thing in a2, usually, I
>can put in one or two letters and it will bring down the info automatically.
>Now it doesn't.
> Any suggestions? Is this a setting that can be turned on or off?

Reply to this Message

C.S.Harris - 11 Mar 2007 09:17 GMT

Thank you very much. That was it exactly.

> For the page break issue................
>
[quoted text clipped - 11 lines]
> >Now it doesn't.
> > Any suggestions? Is this a setting that can be turned on or off?

Reply to this Message

Gord Dibben - 11 Mar 2007 18:14 GMT

Yay! I got one right.

Thanks for the feedback.

Gord

>Thank you very much. That was it exactly.
>
[quoted text clipped - 13 lines]
>> >Now it doesn't.
>> > Any suggestions? Is this a setting that can be turned on or off?

Reply to this Message

Rate this thread: