[Solved] Sort in alphabetic order

Discuss the spreadsheet application
Locked
namely
Posts: 6
Joined: Thu Nov 26, 2015 2:58 am

[Solved] Sort in alphabetic order

Post by namely »

I am not doing anything businessy or advanced with my spreadsheet. I just want to type in all my books and list the author, genre, page count, and date read once I read it otherwise that cell or whatever it is called will be blank until I read it.

My question is how do I make the spreadsheet software alphabetize the list and the information for me because I will not be able to sort my numerous books into alphabetical order before typing it all in.

I also want the information to be with the correct book title.

I know nothing about spreadsheets at all.
Last edited by MrProgrammer on Sat Sep 28, 2024 4:05 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Open Office 4.0.1 Windows 8
FJCC
Moderator
Posts: 9623
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Sort by alphabetic order

Post by FJCC »

Here is one way to do this.
1. Make the first row of the sheet contain the header for each column. Let's say they are Author, Title, Genre, Pages, Date.
2. Fill in the information on each book.
Save a back up copy of the file before going further. Not because this is risky, but because you probably will have spent a lot of time entering data and you should always have a back up of important files.
3. When you are ready to sort click on ONE cell in the area where you have entered information
4. Select the menu Data -> Sort. You should now see that all of the data is highlighted in blue.
5. Use the drop down list in the Sort By area of the Sort dialog to choose the name of the column by which you want to sort.
6. Click OK.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
robleyd
Moderator
Posts: 5504
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Sort by alphabetic order

Post by robleyd »

Slackware 15 (current) 64 bit
Apache OpenOffice 4.1.16
LibreOffice 26.2.3.2; SlackBuild for 26.2.3 by Eric Hameleers
---------------
I hate this damn computer, I wish that I could sell it.
It won't do what I want it to, Only what I tell it.
Alex1
Volunteer
Posts: 852
Joined: Fri Feb 26, 2010 1:00 pm
Location: Netherlands, EU

Re: Sort by alphabetic order

Post by Alex1 »

Use separate columns for the author's first and last names, and a separate column for the article if the title begins with it. That will result in better sorting. Use the title from the title page, not from the cover. Year of publication and publisher are also useful to include.
AOO 4.1.16 & LO 25.8.3 on Windows 10
Locked