How to Catalog Books in Excel – 2 Methods


Method 1 – Creating a Custom Catalog for Books

To create a catalog in Excel:


  • Select the headings.

how to catalog books in excel

  • Separate the columns with a borderline.

  • Select a column. Here, Date of Publication.

  • Press Ctrl+1 to open the Format Cells.
  • Select a data type. Here, Date.
  • Press Enter.

Custom Catalog Books in Excel

  • Freeze the upper header row.
  • Select the row below the header and go to the View tab>Window>Freeze Panes.

  • You can also add a filter to find books in the catalog by going to the Data tab and clicking Data Filter.

Custom Catalog Books in Excel

  • This is the output.

Read More: How to Create Product Catalogue in Excel

Method 2 – Using the Microsoft-Provided Catalog Template


  • Click the link (Book collection list) to download the template.

  • Open the Excel application.
  • Select the downloaded template.
  • The following image will be displayed.

Use the Microsoft-provided Catalog Template

Use the template. You can add or delete fields.

  • Save the file as a .xlsx.
  • Click Files>Save As.
  • Choose .xlsx.


Download Practice Workbook

Download the practice workbook here.

Related Articles

<< Go Back To Catalogue in Excel | Hyperlink in Excel | Linking in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Nasir Muhammad Munim
Nasir Muhammad Munim

Nasir Muhammad Munim has been an Excel and VBA Content Developer for over a year in Exceldemy and published more than 30 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Electrical and Electronic Engineering from the Islamic University of Technology. Apart from creating Excel tutorials, he is interested in developing PostgreSQL, MySQL, and Android applications. He is fascinated by CAD-based designing systems and building... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF