Viewing annoyances

hey I was wondering if there's anyway to disable that horizonatal "snapping" that happens with the columns. It's especially annoying if I want to have a column wider than my screen, since it doesn't let me scroll over it instead jumps to the next column and I can't read the end of the very wide column I have open. Thanks in advance.

qua wrote:
> hey I was wondering if there's anyway to disable that horizonatal
> "snapping" that happens with the columns. It's especially annoying if I
> want to have a column wider than my screen, since it doesn't let me
> scroll over it instead jumps to the next column and I can't read the
> end of the very wide column I have open. Thanks in advance.

I know exactly what you're talking about. I don't think there's a way
to disable that behavior, but I use some workarounds. What kind of data
are you storing in that column? Why does it need to be so wide?

some possible workarounds
- you can left align that column
- if you only need to see 1 row at a time, you can just look in the
"edit formula cell" while you have the cell selected
- make column narrower and use word wrap.

qua wrote:
> hey I was wondering if there's anyway to disable that horizonatal
> "snapping" that happens with the columns. It's especially annoying if I
> want to have a column wider than my screen, since it doesn't let me
> scroll over it instead jumps to the next column and I can't read the
> end of the very wide column I have open. Thanks in advance.

I know exactly what you're talking about. I don't think there's a way
to disable that behavior, but I use some workarounds. What kind of data
are you storing in that column? Why does it need to be so wide?

some possible workarounds
- you can left align that column
- if you only need to see 1 row at a time, you can just look in the
"edit formula cell" while you have the cell selected
- make column narrower and use word wrap.

Change the Zoom percentage so you can get the entire column in your screen.


"qua" wrote:

>
> hey I was wondering if there's anyway to disable that horizonatal
> "snapping" that happens with the columns. It's especially annoying if I
> want to have a column wider than my screen, since it doesn't let me
> scroll over it instead jumps to the next column and I can't read the
> end of the very wide column I have open. Thanks in advance.
>
>
> --
> qua
> ------------------------------------------------------------------------
> qua's Profile: http://www.excelforum.com/member.php...o&userid=36457
> View this thread: http://www.excelforum.com/showthread...hreadid=562216
>
>