exclude headings from sort

  • Thread starter Thread starter eglea
  • Start date Start date
E

eglea

Hi all

how can I set my column headings (cells in row 1) so that they stay on
top when I do sorting?

Thanks!
 
Don't let Excel decide the data to sort - excluding the headers highlight it
firts then sort using Data > Sort and make sure My list has Header Row is
selected

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top