Sorting cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you try to sort certain data by selecting the cells, but leaving
adjacent cells unselected, you get a "sort warning" asking if you would like
to expand the selection. How do you stop this from happening?
 
Joey

If you are selecting cells in one column or row only you will get this
message.

I have never found a way to prevent it.

Hopefully we both can learn something here.


Gord Dibben Excel MVP
 
If I selected the range you want sorted (more than one column and more than one
row), then xl2002 didn't prompt me.

If I just selected one row or one column, I got the prompt.

(But I'm happy that prompt is there!)
 
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 1
When clicking cell near pagebreak cells higlight to the end? 2
Prevent SORT from asking to expand selection in Excel 2007? 4
Problems sorting spreadsheet - Please Help 6
Sorting by rows with differing numbers of cell entries 3
Sorting 3
sorting locked cells 2
Enabling Autofilter and Sorting in a Protected Sheet 2

Back
Top