Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I sort data excluidng headings?
I have created a spreadsheet and freezed the headings so that I can scroll
down and keep the headings on top. Now I am trying to sort the data depending on what information I need (by name, by dollar amount, by state, etc) but when I do it the headings of the columns are also rearranged. How do I keep them on top and just sort out the data? If I just select the data and leave out the heading it will sort it but only by the data in the first colum. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
Column headings to numbers and row headings to alphabets? | Excel Discussion (Misc queries) | |||
Sort headings? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |