Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alphabetize in a block, not just one line
I want to alphabetize everything associated with "Cereal", "hamburger",
"tuna", not just the line cereal, etc. sit on. I want to put "Cereal", then everything associated with "Cereal", prices, stores, etc. then put it in alphabetical order, instead of making room and placing "cereal" in manually. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
alphabetize in a block, not just one line
You may find that putting the key value in a cell on each row in the group--even
if you have to add them manually--will make everything else work better. You'll be able to do sorts, subtotals, pivottables, .... much easier. hilin wrote: I want to alphabetize everything associated with "Cereal", "hamburger", "tuna", not just the line cereal, etc. sit on. I want to put "Cereal", then everything associated with "Cereal", prices, stores, etc. then put it in alphabetical order, instead of making room and placing "cereal" in manually. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphabetize | New Users to Excel | |||
alphabetize | Excel Discussion (Misc queries) | |||
alphabetize - automatically | Excel Worksheet Functions | |||
alphabetize tabs | Excel Discussion (Misc queries) | |||
Alphabetize? | Excel Discussion (Misc queries) |