How to Create an Inventory List in Excel
Method 1 of 2:
Using a Template
- Open Microsoft Excel. It's a dark-green app with a white "X" on it.
- Click the search bar. It's at the top of the Excel window.
- On Mac, first click File in the upper-left corner, then click New from Template… in the drop-down menu.
- Search for inventory list templates. Type inventory list into the search bar at the top of the page, then press ↵ Enter. This will bring up a list of templates for inventory management.
- Select a template. Click on the inventory list template that best suits your needs. Its preview page will open.
- Each inventory list template offers different features. If you don't like the template you've selected, press Esc to return to the templates page.
- Click Create. It's to the right of the template's preview window.
- Wait for your template to load. This may take a few seconds. Once the template is open, you can proceed.
- Enter your inventory information. To change a pre-filled cell, double-click it, delete the number or word there, and enter your item's information. While your selected template may have slightly different options, every inventory list should include the following options:
- Item Number - An item's inventory (SKU) number.
- Item Name - An item's descriptive name.
- Item Cost - The cost of one item.
- Number in Stock - The number of an item.
- Net Value - The total value of an item's stock.
- Save your work. To do so:
- Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the document's name (e.g., "Inventory List") into the "File name" text box, and click Save.
- Mac - Click File, click Save As..., enter the document's name (e.g., "Inventory List") in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save.
Method 2 of 2:
Creating from Scratch
- Open Microsoft Excel. It's a green box with a white "X" in it.
- Click Blank workbook. This box is in the upper-left side of the window.
- Skip this step on Mac.
- Create your inventory list headers. In the following cells, enter the following headers:
- A1 - Item Number
- B1 - Item Name
- C1 - Item Cost
- D1 - Number of Items
- E1 - Net Value
- Adjust the column widths. Click the space between two column letters (e.g., A and B) at the top of the sheet, then drag the mouse to the right to widen the column.
- Enter an item's inventory number. Click cell A2, then type in your item's inventory number (e.g, 123456) and press ↵ Enter.
- Add an item's name. Click cell B2, then enter the item's official name (e.g., Cable ties.
- Determine the item's cost per unit. Click cell C2, then enter the item's individual cost (e.g., 4.99).
- Add the total number of that item that you have on-hand. Click cell D2, then enter the number of items that you have in stock (for example, if you have 80 cable ties on-hand, you'd enter 80).
- Enter the net value formula. Click cell E2, then type
=C2*D2
into the cell and press ↵ Enter. You should immediately see the calculated net value appear in the cell.- You can repeat this general formula for every cell in the "Net Value" column—just make sure that you replace C2 and D2 with the correct cells (for example, if you're multiplying values in cells C10 and D10, you'd use those cells instead of C2 and D2).
- Add the rest of your items to the inventory list. Repeat the above process for each item in your inventory. You'll assign one item to each row until your list is full.
- Save your work. To do so:
- Windows - Click File, click Save As, double-click This PC, click a save location on the left side of the window, type the document's name (e.g., "Inventory List") into the "File name" text box, and click Save.
- Mac - Click File, click Save As..., enter the document's name (e.g., "Inventory List") in the "Save As" field, select a save location by clicking the "Where" box and clicking a folder, and click Save.
4 ★ | 2 Vote
You should read it
- Work with the library item in Adobe Dreamweaver CS6
- 6 best network inventory tools and software of 2023
- How to Remove an Item from the Finder Sidebar on a Mac
- Fix 'Could Not Find This Item…' error in Windows 10
- How to delete items from the New Item menu in File Explorer
- How to Find Your MacBook's Serial Number
- Quick and standard percentage calculation (%)
- How to Use a Vending Machine
May be interested
- How to Open a Password Protected Excel Filethis wikihow teaches you how to remove the password from a protected excel spreadsheet, as well as how to attempt to find out the password for an encrypted excel file. keep in mind that, while removing the password from an editing-locked...
- How to Create a Mortgage Calculator With Microsoft Excelthis wikihow teaches you how to calculate your mortgage-related expenses like interest, monthly payments, and total loan amount using a microsoft excel spreadsheet. once you've done this, you can also create a payment schedule that uses...
- How to Unprotect an Excel Sheetthis wikihow teaches you how to unprotect a sheet within a microsoft excel workbook in windows or macos. if the sheet is protected by a password and you're not sure what it is, you can use google sheets or a vba script (in earlier versions...
- How to Make a Spreadsheet in Excelthis wikihow teaches you the basics of creating your first spreadsheet in microsoft excel. a spreadsheet is a document made of columns and rows of cells that can be used to sort and manipulate data. each cell is designed to hold one piece...
- How to Unhide Rows in Excelthis wikihow teaches you how to force one or more hidden rows in a microsoft excel spreadsheet to display. open the excel document. double-click the excel document that you want to use to open it in excel.
- How to Change from Lowercase to Uppercase in Excelmicrosoft's excel spreadsheet program has several functions to make your text type-case consistent. if you have a series of names that is in the lowercase, you can use 'flash fill' function to capitalize names in excel 2013. if you need...