I'm trying to catalog about 100 items that have 6 or so categories. I have Name, Tier, Type, BossLvl etc. I entered the data for about a dozen of the items, then when I wanted to sort by the boss lvl, that is all it did, without keeping the other items for each name associated. Just the column that was under boss lvl sorted, nothing else, so It doesn't keep the rest of the information tied to that colum. Which messes everything up. I've never worked with office items in any way more than just the barest of tinkering. So if someone can clue me in on how to associate an entire horizontal line of colomns with a sorting process, that would be most helpful. I'm using the Calc program, but would this info be more conducive to a data base instead?
Highlight all the data and select data=>sort and select column to sort by....might be easier with pics; Here's the data Highlight the data....exclude row with column names Select Data=> Sort Select column to sort by and click OK and voila
Why not just apply the AutoFilter!? Select all your data, go to "Data" tab, and turn on "AutoFilter". Now you can add or delete items and filter or sort the whole list on the fly. Just keep in mind that when you add new columns that you will have to re-apply the AutoFilter to all data to make it work
Maybe not much help, but I find Google Sheets to be better than the few "free" alternatives I've tried. (Libre Office/Open Office/etc)
thanks, all, I'll try the filter next. My biggest gripe is that open office has crashed everytime I've used it. You can recover files, but frustrating.
Skip OpenOffice, it's very much outdated. Use LibreOffice or if you like to try something else, go for latest SoftMaker Freeoffice
I changed over to Libre. seems to work without crashing. I even figured out how to get some background color automatically for certain cells. thanks all.