How To Create An Inventory List In Excel With Pictures

On Mac, first click File in the upper-left corner, then click New from Template… in the drop-down menu.

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.

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.

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.

Skip this step on Mac.

A1 - Item Number B1 - Item Name C1 - Item Cost D1 - Number of Items E1 - Net Value

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).

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).

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.