Setting a default sort for a range

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

Guest

How do I set a default data sort on a selected range in Exel. I select from
the collumn that the data need to be sorted on. But I have to select
decending all the time and select no header row all the time. All I want to
do is select the range to sort and hit OK.
 
Have a look in help index for OFFSET and
It might be best to define a name for the range to sort
insert>names>define>name it anything you desire (sortrange)>in the refers to
box
=offset($a$2,0,0,counta($a:$a),6)
 
Back
Top