Excel sheet: resiza rows number??

[furbiuzzu]

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

 

[Norman Jones]

Hi Fulvio,

You cannot change the number of rows - currently 65536.

However, see Debra Dalgleish's suggestions for resetting the used range:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman



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

 

[furbiuzzu]

thanks for your suggestion

i'll try to do that.....

but, being other sheets 'normally' sized and 'adapted', could you tell
me why this problem occurred??

thanks again



Norman Jones ha scritto:

 

[Norman Jones]

Hi Fulvio,

but, being other sheets 'normally' sized and 'adapted', could you tell
me why this problem occurred??

Unless the used range is reset, the range may expand to include data or
formats
entered in a remote area of the worksheet, even if such data is subsequently
deleted.

 

[furbiuzzu]

it worked fine, thanks !!!