View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Crosscom
 
Posts: n/a
Default How to sort in excell

Thanks that works.

"Mark Lincoln" wrote:

Try creating a named range by selecting the area you want to sort, then
selecting Insert|Name|Define... and typing in the name you wish (e.g.,
I use "SortRange").

Then type "SortRange" into the name box (to the left of the formula
bar) - or just select - and you'll have your range selected and ready
to sort.