View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default How many entries can Excel handle!?

And Excel 2003 has a limit of 65535 rows and 256 columns.

Your 1000 entries really should not be a problem. Have you checked to see
if perhaps your special sorting has placed some entries in places on the
sheet where you may not be looking?

A quick way to find out how far down and over on a sheet your data extends
is to click in a cell on a sheet and then press [Ctrl]+[End]. This will take
you to the lower right corner of the used range on a sheet. You can then
start looking to the left and up the sheet for your data.

"Rebecca Sage" wrote:

I have close to 1000 entries in my Excel spreadsheet, and am trying to figure
out why entries are coming up missing. I often do custom sorts. This may be
when entries get tossed out?