Follow these steps to create your own inventory sheet. Here’s how to create your own inventory sheet in just four steps: Step 1. Open a Spreadsheet. You can use any spreadsheet you like.

Create a total row to calculate the total number of units and total value of inventory. If you ended at row "27," then move to row "28." In cell "F28" enter the formula "=SUM(F5:F27)" to obtain ...