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?
|