View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How do I sort a database without also sorting the column heading?

From menu DataSort window under the label 'My data range has' check "Header
row'

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


"Nikki Carter Johnson" wrote:

Hi, I've created a datase and I'm trying to sort it alphabetically, but for
some reason the titles at the top of the columns are also sorting. How do I
format the database so that Excel knows that the column headings are titles?
Your help would be much appreciated. Thanks, Nikki