sorting issue

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hi,

When a range of columns are highlighted and a sort is performed on only one
column empty cells above the sort display first. How can this be prevented.
I know when there is data in any of the other column but not on the column
being sorted this will happen.

Any thoughts?
Pat
 
Are you sure the cells are really empty?

They don't contain spaces or even formulas that evaluate to "". (Even formulas
converted to values that returned "")?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting 12
writing a sort macro 2
Sorting Datain a Shared Workbook 2
Sorting issue with frozen panes 11
Sorting several columns 1
Columns not sorting properly. 2
Sort Contiguous Columns - Danger 3
Sort Issue 2

Back
Top