How to Make Catalogue in Excel (with Easy Steps)

In this article, I will show you how to make a catalogue in Excel. As we know, a catalogue is a collection of items, organized systematically to make searching for any items more accessible for the customers. As Microsoft Excel is an excellent tool for organizing things, we can use Excel to make a catalogue of numerous items with very simple and easy steps. If you are wondering how you can make a catalogue in Excel for your company, you have come to the right place. Here, I will make a template file that you can edit according to your needs. So let’s get started.

How to Make Catalogue in Excel: with Easy Steps

The format of a catalogue can vary significantly depending on the kind and range of business items it includes. Here, I will create a product catalogue in Excel for a small online e-commerce site. By following the steps, you can make your own catalogue and customize it according to your needs.

Step 1: Giving a Suitable Title to the Catalogue

  • In this step, we will first open an Excel file and give a suitable title to the workbook where I will make my catalogue. So, first, open a fresh Excel file.
  • Now on the 2nd row of the workbook, take some cells (I took B2: G2), merge them, and give a suitable title. I have given the title “Product Catalogue of Evaly”. (see the figure below)

how to make catalogue in excel

  • Now, make some modifications to the formatting of the title so that it looks more attractive and elegant. Here, I have changed the cell colour and made the font larger, and set the middle alignment.

Step 2: Entering Column Header of the Catalogue

  • Now that we have given a suitable title to our catalogue, we will start inserting the column headers that are appropriate to our company’s requirements. The company I have taken is an e-commerce company that sells a wide range of products from cosmetics, and beauty products to lifestyle, electronics, and health gadgets. Thus, the fields that I need to insert in order to properly specify the products are taken as shown in the picture below.

how to make catalogue in excel

  • Here, you have to make sure that you have included all the necessary fields to identify and arrange all the products of your business.

Step 3: Entry of the Product Information

  • This time, we need to enter the required info on all the products related to the column headers.

how to make catalogue in excel

  • If you also want to add a product picture as I did, you need to make the row height larger (I have taken 50) and insert a picture by going to the Insert tab and then Illustrations >> Pictures >> This Device.

how to make catalogue in excel

  • Now, select the image File and click on Insert.

how to make catalogue in excel

  • After inserting the image, you have to adjust the size of the picture to fit into the cell under the picture column.

Read More: How to Make a Picture Catalog in Excel

Step 4: Creating a Table

  • Now, you can turn the whole catalogue into an Excel table to enable the Sort & Filter feature which will allow you to find the same category items quickly. To do that, select the whole dataset and press Ctrl+L. As a result, a dialogue box named “Create Table ” will appear. Now, click on My table has headers and then select OK.

  • As a result, an Excel table will be created with the Sort & Filter feature.

  • Now, if you want to show just one category of product, you can use the filter feature. Here, I am only showing the Cosmetic items. To that, click on the drop-down icon under the Category and select Cosmetic. Finally, click OK.

how to make catalogue in excel

  • As a result, you will only see the Cosmetic category products.

how to make catalogue in excel

In this way, we can make a catalogue in Excel.

Things to Remember

  • Add extra columns (Brand name, tag, etc.) if you need to make it more appropriate for your company.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


That is the end of this article on how to make a catalogue in Excel. If you find this article helpful, please share this with your friends. Moreover, do let us know if you have any further queries.

Related Articles

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

Get FREE Advanced Excel Exercises with Solutions!
Aniruddah Alam
Aniruddah Alam

Md. Aniruddah Alam, a graduate of Bangladesh University of Engineering & Technology, Dhaka, holds a BSc.Engg in Naval Architecture & Marine Engineering. Joining Softeko in August 2022 as an Excel and VBA content developer, he has authored 90+ articles, covering fundamental to advanced Excel topics. He actively develops VBA codes for Excel automation and offers solutions in the Exceldemy Forum. Beyond work, he finds leisure in reading books, and taking relaxing walks, showcasing well-rounded blend of professional and... Read Full Bio

  1. How can I prevent pictures from bunching up at the top of the column when I sort by category. All the pictures from the unselected category got to the top cell in the row.

    • Reply Lutfor Rahman Shimanto
      Lutfor Rahman Shimanto Mar 18, 2024 at 12:32 PM


      Thanks for visiting our blog and sharing your problem. When sorting categories, you get all the pictures from the unselected category in the top cell of the row.

      To overcome your situation, you can insert images using the Place in Cell feature, like the following GIF.

      I am delighted to inform you that I have developed an automated solution for you using the Excel VBA Event procedure and Sub-procedure. Please, follow these steps:

      1. Right-click on the sheet name tab.
      2. Click on View Code.
      3. Insert the following code in the sheet module and save it:
        Private Sub Worksheet_SelectionChange(ByVal Target As Range)
            If Not Intersect(Target, Me.Range("G5:G11")) Is Nothing Then
                Call InsertAndFitImage
            End If
        End Sub
        Sub InsertAndFitImage()
            Dim cellAddresses As Variant
            Dim cellAddress As Variant
            Dim imgFile As Variant
            Dim pic As Picture
            Dim i As Long
            Dim cell As Range
            Dim mergedWidth As Double
            Dim mergedHeight As Double
            Dim ThisPath As String
            cellAddresses = Array("G5:G11")
            With Application.FileDialog(msoFileDialogFilePicker)
                .Title = "Choose Images"
                 If .Show = -1 Then
                    For i = 1 To .SelectedItems.Count
                        cellAddress = cellAddresses(i - 1)
                        Set cell = ThisWorkbook.ActiveSheet.Range(cellAddress)
                        ThisPath = .SelectedItems(1)
                        cell.InsertPictureInCell (ThisPath)
                    Next i
                End If
            End With
        End Sub

      4. Return to the sheet and insert the intended images in the selected cell, like the following GIF.

      As a result, you will no longer see pictures from the unselected categories in the top row cell when filtering or sorting categories, like the following GIF.

      I am attaching the solution workbook for better understanding; good luck.


      Lutfor Rahman Shimanto
      Excel & VBA Developer

Leave a reply

Advanced Excel Exercises with Solutions PDF