short the scrolls

[yoniman]

A funny problem:
When u open a new sheet the down scroll is limited to the screen size - very comfortably the scroll automatically increases its span as one uses more rows.

HOW DO I REVERSE IT?!?!

I had a 10K rows and I narrowed them to 100 (transpose). How can I shorten the scroll down ruler?

I will really appreciate any help (the trivial copy/paste to a new sheet I know)

yoniman

[oldchippy]

Hi,

Although you may have deleted the cell contents below 100 rows, excel is still "saving" that space (say row 101:1000). What you need to do is to select the rows you were using below 100 rows and then delete those rows, then save the file.

[yoniman]

thanks a lot oldchippy