| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort without including column headings in sort
I can't find the answer either online or in Excel help probably because I'm
not using correct terms. The first row contains column titles, and when I sort the columns these titles get sorted to. Can I somehow anchor or designate the text in these cells to remain fixed? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort without including column headings in sort
I should say I'm using Excel 2002.
-- OPDvolunteer "OPDvolunteer" wrote: I can't find the answer either online or in Excel help probably because I'm not using correct terms. The first row contains column titles, and when I sort the columns these titles get sorted to. Can I somehow anchor or designate the text in these cells to remain fixed? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort without including column headings in sort
Don't know what version of Excel you are using but in Excel 2000 when you
select your columns and then click Data - Sort, the Sort dialog box has a radio button at the bottom to say whether your columns have a header row or not. "OPDvolunteer" wrote: I can't find the answer either online or in Excel help probably because I'm not using correct terms. The first row contains column titles, and when I sort the columns these titles get sorted to. Can I somehow anchor or designate the text in these cells to remain fixed? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort without including column headings in sort
Try formatting the headers differently, like Bold. Excel will probably
recognize them then as headers -- Kind regards, Niek Otten Microsoft MVP - Excel "OPDvolunteer" wrote in message ... I should say I'm using Excel 2002. -- OPDvolunteer "OPDvolunteer" wrote: I can't find the answer either online or in Excel help probably because I'm not using correct terms. The first row contains column titles, and when I sort the columns these titles get sorted to. Can I somehow anchor or designate the text in these cells to remain fixed? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to sort without including column headings in sort
PERFECT! I'm using 2002 and it has the same options. Many thanks.
-- OPDvolunteer "RonaldoOneNil" wrote: Don't know what version of Excel you are using but in Excel 2000 when you select your columns and then click Data - Sort, the Sort dialog box has a radio button at the bottom to say whether your columns have a header row or not. "OPDvolunteer" wrote: I can't find the answer either online or in Excel help probably because I'm not using correct terms. The first row contains column titles, and when I sort the columns these titles get sorted to. Can I somehow anchor or designate the text in these cells to remain fixed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a worksheet without including the column header row | Excel Discussion (Misc queries) | |||
| Sort Not Including Top Row | Excel Discussion (Misc queries) | |||
| data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
| How can I sort one column and have the entire row sort. (binding) | Excel Worksheet Functions | |||
| data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
Linear Mode
