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.
[Solved] Sort in alphabetic order
[Solved] Sort in alphabetic order
Last edited by MrProgrammer on Sat Sep 28, 2024 4:05 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Reason: Tagged ✓ [Solved] -- MrProgrammer, forum moderator
Open Office 4.0.1 Windows 8
Re: Sort by alphabetic order
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.
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Sort by alphabetic order
See also [Tutorial] Simple sorting.
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.
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.
Re: Sort by alphabetic order
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