what type of worksheet?

Copper Contributor

What kind of worksheet / formula / functions should I use?  I want to make a document that lists books, and can be sorted by title, author, date added to list, reader rating, and have some color coding.  New data will be added regularly.  What kind of table or spreadsheet or worksheet should I use?  

1 Reply


Use a standard Excel table. They can be sorted based on any of the columns, singly or in combination.


The attached is a starter. Don't worry about color coding at this stage of your learning. Once you've learned the basics, do some research on Conditional Formatting.


All of the blue highlights in this reply are hyperlinks where you can continue learning. But you'd do well to go get a book on Excel basics.