Free Inventory Software You Can Upload Excel Spreadsheet

Download Article

Download Article

This wikiHow teaches y'all how to manage your business' inventory using an Excel spreadsheet on a Windows or Mac computer. Y'all can utilize a pre-formatted inventory listing template to do this, or yous tin manually create your sheet.

1. 1

   Open Microsoft Excel. It's a dark-green app with a white "X" on information technology.

2. two

   Click the search bar. It's at the tiptop of the Excel window.

   • On Mac, first click File in the upper-left corner, then click New from Template… in the drib-downwardly carte.

   Ad

3. 3

   Search for inventory list templates. Type inventory list into the search bar at the peak of the page, and then press ↵ Enter . This will bring up a listing of templates for inventory management.

4. 4

   Select a template. Click on the inventory list template that best suits your needs. Its preview folio volition open.

   • Each inventory list template offers different features. If you don't similar the template you've selected, press Esc to return to the templates page.

5. v

   Click Create . Information technology's to the right of the template's preview window.

6. 6

   Wait for your template to load. This may take a few seconds. One time the template is open up, you tin proceed.

7. vii

   Enter your inventory data. To change a pre-filled prison cell, double-click it, delete the number or word there, and enter your particular'southward information. While your selected template may have slightly unlike options, every inventory list should include the following options:

   • Item Number - An detail'south inventory (SKU) number.
   • Detail Proper name - An detail'south descriptive proper name.
   • Item Cost - The cost of one item.
   • Number in Stock - The number of an detail.
   • Internet Value - The total value of an detail's stock.

8. 8

   Salvage your work. To do and then:

   • Windows - Click File, click Salve As, double-click This PC, click a salvage location on the left side of the window, type the document'due south name (east.g., "Inventory List") into the "File name" text box, and click Salve.
   • Mac - Click File, click Salve As..., enter the document'south proper name (e.g., "Inventory List") in the "Save As" field, select a save location past clicking the "Where" box and clicking a folder, and click Save.

   Advert

1. 1

   Open Microsoft Excel. It'southward a green box with a white "10" in it.

2. ii

   Click Bare workbook . This box is in the upper-left side of the window.

   • Skip this step on Mac.

3. 3

   Create your inventory list headers. In the post-obit cells, enter the post-obit headers:

   • A1 - Detail Number
   • B1 - Item Proper noun
   • C1 - Item Cost
   • D1 - Number of Items
   • E1 - Net Value

4. 4

   Accommodate the column widths. Click the infinite betwixt ii cavalcade messages (eastward.g., A and B) at the superlative of the sheet, then elevate the mouse to the correct to widen the cavalcade.

5. 5

   Enter an particular'south inventory number. Click cell A2, then type in your item's inventory number (e.g, 123456) and press ↵ Enter .

6. 6

   Add an item's proper noun. Click cell B2, and so enter the item's official proper noun (eastward.1000., Cablevision ties).

7. 7

   Determine the detail'southward toll per unit. Click jail cell C2, then enter the detail's individual toll (e.g., four.99).

8. 8

   Add the total number of that item that you take on-manus. Click cell D2, then enter the number of items that you have in stock (for example, if you have 80 cable ties on-hand, y'all'd enter 80).

9. nine

   Enter the cyberspace value formula. Click cell E2, then type =C2*D2 into the cell and printing ↵ Enter . You should immediately meet the calculated internet value appear in the jail cell.

   • You can repeat this general formula for every prison cell in the "Internet Value" column—only brand certain that you supervene upon C2 and D2 with the correct cells (for example, if you're multiplying values in cells C10 and D10, yous'd use those cells instead of C2 and D2).

10. x

    Add the residuum of your items to the inventory list. Repeat the above process for each particular in your inventory. Yous'll assign one item to each row until your list is full.

11. 11

    Save your work. To exercise 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'due south name (east.grand., "Inventory List") into the "File proper noun" text box, and click Salvage.
    • Mac - Click File, click Save As..., enter the document's proper name (eastward.g., "Inventory List") in the "Save Equally" field, select a salvage location by clicking the "Where" box and clicking a folder, and click Save.

    Advertisement

Add New Question

• Question

  Why should I format my text to wrap in Excel?

  

  By formatting text to wrap on your headers, Excel volition automatically extend the text into the prison cell beneath if yous take a title that does not fit in the box. This allows you lot to create headers with longer titles without having to widen your columns, which can get disorganized if they grow too wide.

• Question

  How do I freeze panes in Excel?

  

  Sulaman Mubarak

  Customs Respond

  Go on the "view" option and right under the view tab you lot volition see the freeze pane option.

Ask a Question

200 characters left

Include your email address to become a message when this question is answered.

Submit

Advertisement

• Yous tin can add another sheet to your workbook by clicking ＋ in the lower-left side of the page.

Advertisement

Almost This Article

Thanks to all authors for creating a folio that has been read 720,151 times.

Is this article upward to date?

solomongodiever.blogspot.com

Source: https://www.wikihow.com/Create-an-Inventory-List-in-Excel

Share this post