Blogging by Solveig Haugland, writer of the Guidebook and owner of Tips for using, transitioning, and more.

You are watching: How to alphabetize in openoffice calc


« Direct publication sales are on again |Main| brand-new book around a Medicare whistle-blower »

April 21, 2008

You want to do some good, difficult sorting. Not simply sorting by the very first column, however by probably the third column. Maybe you desire to sort an initial by state, then by city, then by critical name. Because that that, you need the Sort home window under Data > Sort.

You have actually your data. Choose all the data come sort, and also either choose the headings or not. You"re an excellent either way.

Choose Data > Sort.

Click the alternatives tab. You should tell Calc whether you"ve acquired headings selected or not. If you"ve gained headings selected, you desire the option shown, "Range consists of Column Labels," to be selected. If friend didn"t, unmark it.

Now click the type Criteria tab. If friend selected headings you"ll view the headings themselves; if friend didn"t climate you"ll just see obelisk A, etc. Pick the shaft to sort by, and Ascending or Descending.

Click OK.

You obtain your results. Here, the amounts under the obelisk for the year 2000 space sorted in ascending order.

Now, let"s look in ~ a different set of data. You have a many of people from the very same state, and several cities per state. In this situation you can want to just sort by critical name, yet you could likewise group by location. For this reason you"d kind by state (the broadest category), then city, climate alphabetically by last name. Click the image to see more detail.

Select the data, through or without headings, and also choose Data > Sort. In the choices tab, be sure to pick the variety Contains obelisk Labels alternative if girlfriend selected headings.

In the sort Criteria tab, select an initial State, climate City, climate Last Name.

Click OK.

You gain your results. Here"s a closeup the one section, adhered to by the complete data. Click one of two people to see them closeup.

This window that I"ve spanned in this blog entrance is pretty lot what friend need. If you want to walk a tiny farther and also sort by miscellaneous else, like days of the mainly in the order castle come, not alphabetical order, song in because that the next sorting blog.

See more: Science For What Do Plants And Animals Need Nitrogen Cycle, The Nitrogen Cycle


Posted in ~ 06:24 am in Calc: 2008 | Permalink

I understand this has nothing to execute with your post, however I am at a loss as to how to perform a (seemingly) simple function in Calc. I have a shaft containing sequential dates through the year, and also in the next column, in every seven cells, ns would favor to have actually a date range of the previous week listed. Does this make sense? (I've written & rewritten & rewritten AGAIN this question, and it still seems confusing.

For example:

Column A has descending work of the main listed:Sun = cell A1Mon = cabinet A2Tues = cabinet A3Wed = cell A4Thurs = cell A5Fri = cell A6Sat = cabinet A7(etc...)

......I hope this provides SOME kind of sense to you, because I am dumbfounded on exactly how this can be completed without typing our the day ranges as text throughout the whole year and for annually to come.