Thread: I'd like to Sort one column without affecting the others
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default I'd like to Sort one column without affecting the others
If you select the entire column by header you will get the Sort Warning dialog.

If you select just the top cell in the column Excel will automatically select
the current region with no warning.


Gord Dibben MS Excel MVP

On Tue, 2 Oct 2007 11:44:01 -0700, Legna105
wrote:

And the Sort Warning dialog box has been disabled somehow, so I can't click
"Continue with the current selection." Does anyone know how to re-enable the
sort warning dialog box?

Reply With QuoteReply With Quote