View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default sort a table without including titles which r on each page

Select the range
From menu DataSort
Select 'My data range has' Headers
Select Sort by select the header name
Select ascending/Descending and then OK.

If this post helps click Yes
---------------
Jacob Skaria


"Sara's gran" wrote:

Can anyone help me? I am trying to sort a table with titles "Song Title,
Song # and Artist" on each page - it is a karaoke list - I want to sort the
song titles but the titles get included in the sort - how do I sort the list
without having the headings (Song title, song #, etc.) being included in the
sort & placed under the "S"

Need help - thank you in advance.

Helen