Excel can't find the end of the spreadsheet (Ctrl+end)

[verc]

Hi all,

Recently I've started to be given spreadsheets of data to analyze, an
the spreadsheet extends to 65000 rows even though there are more lik
2-3000, such that when I try to press ctrl-end to go to the last row
it takes me to 65000 instead of where I actually want to go. Can anyon
suggest a fix for this?

Thanks,
Amber

 

[Debra Dalgleish]

There are instructions here for manually or programmatically resetting
the used range:

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

 

[Geovas]

Excel has a limit of 65536 rows so you cannot have more rows than that in a
spreadsheet.