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

Hi all,

Recently I've started to be given spreadsheets of data to analyze, and
the spreadsheet extends to 65000 rows even though there are more like
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 anyone
suggest a fix for this?

Thanks,
Ambert


--
verc
------------------------------------------------------------------------
verc's Profile: http://www.excelforum.com/member.php...o&userid=15963
View this thread: http://www.excelforum.com/showthread...hreadid=274391

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

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


verc wrote:
Recently I've started to be given spreadsheets of data to analyze, and
the spreadsheet extends to 65000 rows even though there are more like
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 anyone
suggest a fix for this?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

Ï "verc" Ýãñáøå óôï ìÞíõìá
...

Hi all,

Recently I've started to be given spreadsheets of data to analyze, and
the spreadsheet extends to 65000 rows even though there are more like
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 anyone
suggest a fix for this?

Thanks,
Ambert


--
verc
------------------------------------------------------------------------
verc's Profile:
http://www.excelforum.com/member.php...o&userid=15963
View this thread: http://www.excelforum.com/showthread...hreadid=274391