Sorting but not the headings
 

I'm tying to sort all the family birthdays but when I do, the headings get
sorted too.
How do I sort birthdays without sorting the headings of columns Date of
birth, Name, address, ect...
Thank you if you can help.

Sorting but not the headings
 

In the sort dialog specify that the columns have headers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ron" wrote in message
...
I'm tying to sort all the family birthdays but when I do, the headings get
sorted too.
How do I sort birthdays without sorting the headings of columns Date of
birth, Name, address, ect...
Thank you if you can help.

Sorting but not the headings
 

Format the headers differently, like Bold

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ron" wrote in message
...
I'm tying to sort all the family birthdays but when I do, the headings get
sorted too.
How do I sort birthdays without sorting the headings of columns Date of
birth, Name, address, ect...
Thank you if you can help.

Sorting but not the headings
 

if you highlight the data you want to sort (and not the headings ) and then
do a sort
hope this helped.

"Ron" wrote:

I'm tying to sort all the family birthdays but when I do, the headings get
sorted too.
How do I sort birthdays without sorting the headings of columns Date of
birth, Name, address, ect...
Thank you if you can help.