| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
| Setting up account headings for sorting data that is dynamic | Excel Discussion (Misc queries) | |||
| Sorting rows to match headings | Excel Discussion (Misc queries) | |||
| sorting column headings | Setting up and Configuration of Excel | |||
| Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions | |||
Linear Mode
