Excel Spreadsheet

  • Thread starter Thread starter Paul Nudds
  • Start date Start date
P

Paul Nudds

I have large database on Excel but the search & sort will
not work correctly over a certain size ?? is there a
preset limit rto how much it can sort ..if so how do i
alter
 
Paul

The most likely explanation is that the whole area is not being selected
prior to the search. Try again, making sure that the whole range is selected
before you start the sort.

Andy.
 
Or that the data is not all in the same format, ie mixture of numeric and text fields, despite all
looking one way or the other.

If your data is supposed to be numeric, then copy an empty cell, select the whole range of data
and do edit / Paste Special / Add. this will coerce any rogue text cells to numeric.
 
Back
Top