• About
  • Contact
  • Cookie
  • Disclaimer
  • Privacy Policy
  • Change the purpose of use

Tnhelearning.edu.vn - Various useful general information portal

  • Photo
  • Bio
  • How To
  • Tech

How to Create an Inventory List in Excel

January 30, 2024 by admin Category: How To

You are viewing the article How to Create an Inventory List in Excel  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 4,240 times.

This wikiHow teaches you how to manage a work inventory using an Excel spreadsheet on your Windows or Mac computer. You can use a pre-formatted inventory list template, or create your own sheet.

Table of Contents

  • Steps
    • Use templates
    • Create each part by yourself
  • Advice

Steps

Use templates

Image titled Create an Inventory List in Excel Step 1

Image titled Create an Inventory List in Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c4/Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c4/Create-an- Inventory-List-in-Excel-Step-1-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-1-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. Dark green app with a white “X” inside.
Image titled Create an Inventory List in Excel Step 2

Image titled Create an Inventory List in Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/78/Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/78/Create-an- Inventory-List-in-Excel-Step-2-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-2-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the search bar at the top of the Excel window.

  • On a Mac, click File in the upper-left corner first, then click New from Template… in the drop-down menu.
Image titled Create an Inventory List in Excel Step 3

Image titled Create an Inventory List in Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/Create-an- Inventory-List-in-Excel-Step-3-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-3-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Find the inventory list template. Type inventory list in the search bar at the top of the page and then press ↵ Enter . A list of samples used for product inventory will appear.
Image titled Create an Inventory List in Excel Step 4

Image titled Create an Inventory List in Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2f/Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2f/Create-an- Inventory-List-in-Excel-Step-4-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-4-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Sampling. Click on the inventory list template that best suits your needs. The template preview page opens.

  • Each inventory template offers different features. If you don’t like the template you just selected, you can press Esc to return to the template page.
Image titled Create an Inventory List in Excel Step 5

Image titled Create an Inventory List in Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/1a/Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/1a/Create-an- Inventory-List-in-Excel-Step-5-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-5-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Create on the right side of the template preview window.
Image titled Create an Inventory List in Excel Step 6

READ More:   How to Write a Farewell Speech

Image titled Create an Inventory List in Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/85/Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/85/Create-an- Inventory-List-in-Excel-Step-6-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-6-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Wait for the sample to be loaded. This process will take a few seconds. Once the template opens, you can continue.
Image titled Create an Inventory List in Excel Step 7

Image titled Create an Inventory List in Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ca/Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ca/Create-an- Inventory-List-in-Excel-Step-7-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-7-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter inventory information. To change a pre-filled cell, double-click the cell, delete the number or text in it, and then enter your data. While the template you choose may vary slightly, all inventory lists include the following options:

  • Item Number – The inventory number (SKU or inventory unit) of the item.
  • Item Name – The name that describes the item.
  • Item Cost – The price per unit of the item.
  • Number in Stock – Number of items in stock.
  • Net Value – The net value of the item.
Image titled Create an Inventory List in Excel Step 8

Image titled Create an Inventory List in Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e9/Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e9/Create-an- Inventory-List-in-Excel-Step-8-Version-5.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-8-Version-5.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Save the work. To save a document:

  • Windows – Click File , click Save As , double click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the box text “File name” and then click Save .
  • Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .

Create each part by yourself

Image titled Create an Inventory List in Excel Step 9

Image titled Create an Inventory List in Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/61/Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/61/Create-an- Inventory-List-in-Excel-Step-9-Version-4.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-9-Version-4.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. Dark green app with a white “X” inside.
Image titled Create an Inventory List in Excel Step 10

Image titled Create an Inventory List in Excel Step 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a4/Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a4/Create-an- Inventory-List-in-Excel-Step-10-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Blank workbook . This box is in the upper left of the window.

  • Skip this step if you’re on a Mac.
Image titled Create an Inventory List in Excel Step 11

Image titled Create an Inventory List in Excel Step 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cd/Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cd/Create-an- Inventory-List-in-Excel-Step-11-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-11-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a title for your inventory list. Enter the corresponding title in the following boxes:

  • A1 – Item Number or Inventory Number
  • B1 – Item Name or Item Name
  • C1 – Item Cost or Item Price
  • D1 – Number of Items or Number of Items
  • E1 – Net Value or Net Value
READ More:   How to Give Dogs Pills
Image titled Create an Inventory List in Excel Step 12

Image titled Create an Inventory List in Excel Step 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2e/Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2e/Create-an- Inventory-List-in-Excel-Step-12-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Adjust column widths. Click the space between the two letters of the column name (for example, A and B ) at the top of the worksheet, then drag your mouse to the right to expand the column.
Image titled Create an Inventory List in Excel Step 13

Image titled Create an Inventory List in Excel Step 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/99/Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/99/Create-an- Inventory-List-in-Excel-Step-13-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the item’s inventory number. Click in cell A2 , then enter the item code (such as 123456 ) and press ↵ Enter .
Image titled Create an Inventory List in Excel Step 14

Image titled Create an Inventory List in Excel Step 14

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2a/Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2a/Create-an- Inventory-List-in-Excel-Step-14-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add item name. Click cell B2 , then enter the item’s official name (ex: Drawstring ).
Image titled Create an Inventory List in Excel Step 15

Image titled Create an Inventory List in Excel Step 15

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/58/Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/58/Create-an- Inventory-List-in-Excel-Step-15-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Determine the unit price of the item. Click cell C2 , then enter the individual item’s cost (such as 50,000 ).
Image titled Create an Inventory List in Excel Step 16

Image titled Create an Inventory List in Excel Step 16

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/97/Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/97/Create-an- Inventory-List-in-Excel-Step-16-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add the total number of existing items. Click cell D2 and enter the number of items you have in stock (for example, if you currently have 80 drawstring sets, enter 80 ).
Image titled Create an Inventory List in Excel Step 17

Image titled Create an Inventory List in Excel Step 17

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/26/Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/26/Create-an- Inventory-List-in-Excel-Step-17-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-17-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the formula for calculating net worth. Click in cell E2 , then type =C2*D2 in the cell and then press ↵ Enter . You will see the net value calculated and shown in the box.

  • You can repeat this general formula with each cell in the “Net Value” column—just remember to replace C2 and D2 with the appropriate cell (for example, if you’re multiplying the values of cells C10 and D10 , you’ll need to use name these cells instead of C2 and D2 ).
Image titled Create an Inventory List in Excel Step 18

Image titled Create an Inventory List in Excel Step 18

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c5/Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c5/Create-an- Inventory-List-in-Excel-Step-18-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-18-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Add the remaining items to the inventory list. Repeat the above process for each item to be inventoryed. You need to assign each item to each line until the list is complete.
  • Image titled Create an Inventory List in Excel Step 19

    READ More:   How to Create a Waterproof Layer for Wood

    Image titled Create an Inventory List in Excel Step 19

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c7/Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg/v4-728px- Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c7/Create-an- Inventory-List-in-Excel-Step-19-Version-2.jpg/v4-728px-Create-an-Inventory-List-in-Excel-Step-19-Version-2.jpg”,”smallWidth”:460 ,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
    Save the work. To save a document:

    • On Windows – Click File , click Save As , double-click This PC , click a save location on the left side of the window, enter a name for the document (such as “Inventory List”) in the “File” text box name” and then click Save .
    • Mac – Click File , click Save As… , enter a name for the document (such as “Inventory List”) in the “Save As” field, choose a save location by clicking the “Where” box “, click the folder, and then click Save .
  • Advice

    • You can add more worksheets to the worksheet set by clicking the + sign in the lower left of the page.
    X

    This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

    The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

    This article has been viewed 4,240 times.

    This wikiHow teaches you how to manage a work inventory using an Excel spreadsheet on a Windows or Mac computer. You can use a pre-formatted inventory list template, or create your own sheet.

    Thank you for reading this post How to Create an Inventory List in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks

    Category: How To

    Previous Post: « What is a mortgage? Mortgage loan procedure?
    Next Post: What is underwear laundry detergent? Top 7 best underwear washing liquid today »

    Copyright © 2025 · Tnhelearning.edu.vn - Useful Knowledge