ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Horizontal Scrolling (https://www.excelbanter.com/excel-programming/424771-horizontal-scrolling.html)

kirkm[_8_]

Horizontal Scrolling
 

I've rather a large amount of data and as your scroll horizontilly
to read it, at some point it jumps making it almost impossible to
read.

Is there anyway to make it scroll smoothly? I suspect it's something
to with cell width. My data exceeds the 255 limit though, so I've just
let it use one cell with the text going over the cells to the right.

Thanks - Kirk

Chip Pearson

Horizontal Scrolling
 
When you scroll horizontally or vertically, Excel always moves the
sheet so that the left (or bottom) edge is on a column (or row)
border. If you have wide columns, scrolling will cause the display to
"jump" from one column to the next. There is no ways to scroll or
position the worksheet so that the left-most column is only partially
visible. Excel will force the alignment so that the left-most column
is fully visible.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 28 Feb 2009 17:38:06 +1300, kirkm wrote:


I've rather a large amount of data and as your scroll horizontilly
to read it, at some point it jumps making it almost impossible to
read.

Is there anyway to make it scroll smoothly? I suspect it's something
to with cell width. My data exceeds the 255 limit though, so I've just
let it use one cell with the text going over the cells to the right.

Thanks - Kirk


Linux4ever

Horizontal Scrolling
 
This "feature" is very annoying and should be configurable by the user. It
is very unnatural when there is no proper linear feedback between mouse
movement and action on screen. Yet another reason not to choose Microsoft
products.

// DD

"Chip Pearson" wrote:

When you scroll horizontally or vertically, Excel always moves the
sheet so that the left (or bottom) edge is on a column (or row)
border. If you have wide columns, scrolling will cause the display to
"jump" from one column to the next. There is no ways to scroll or
position the worksheet so that the left-most column is only partially
visible. Excel will force the alignment so that the left-most column
is fully visible.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 28 Feb 2009 17:38:06 +1300, kirkm wrote:


I've rather a large amount of data and as your scroll horizontilly
to read it, at some point it jumps making it almost impossible to
read.

Is there anyway to make it scroll smoothly? I suspect it's something
to with cell width. My data exceeds the 255 limit though, so I've just
let it use one cell with the text going over the cells to the right.

Thanks - Kirk




All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com