Quizzes & Puzzles1 min ago
creatiing a list
4 Answers
I want to catalogue my books, which are many, and I want to create an alphabetical list on my computer - being compute illiterate, I do not know how to do this - I would like to be able to make lists of authors alphabetically, and also, separately, lists of books by subject, e.g. gardening, cookery, biology, histories, etc. Any help would be much appreciated.
Answers
Best Answer
No best answer has yet been selected by gardenmad. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Use your spreadsheet programme (eg. Excel) to create a very simple database. Create columns for author (in the format 'Last Name, First Name', Title (moving any 'The's or 'A's to the end, following a comma), and any other info you want to use - ISBN, subject or whatever.
Now, say you want to order them by title - highlight all the rows you want to order, then click Data > Sort. You'll get a box asking you whether you've included your header rows or not, and which column you want to sort by first. Just select the options you need, click OK, and wahay - you're there!
You could use a database programme, but if you're not too computer-savvy they can be quite long winded to set up and can sometimes do quite alarming things if you're not too sure what you're doing.
I use Excel to manage our library service's 400 odd subscription titles in this way, and it hasn't let me down yet.
Now, say you want to order them by title - highlight all the rows you want to order, then click Data > Sort. You'll get a box asking you whether you've included your header rows or not, and which column you want to sort by first. Just select the options you need, click OK, and wahay - you're there!
You could use a database programme, but if you're not too computer-savvy they can be quite long winded to set up and can sometimes do quite alarming things if you're not too sure what you're doing.
I use Excel to manage our library service's 400 odd subscription titles in this way, and it hasn't let me down yet.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.