How could i resize the number of rows inside an excel sheet?'

actually i've to work with a maximum of 10.000 rows but, i don't know
why, my vertical bar is sized to 30.000 rows, so i've some problems to
reach an intermediate row quickly because of the high range the
vertical bar has to cover...

actually my data are less than 3000.. i would like to have:

1) a sheet with a maximum of 10K rows
2) a vertical bar "proportional" to sheet n° of used rows

is this possible??

NB.

in the same file but other sheets i don't see this problem, everything
works right......


thanks in advance.

fulvio, salvo