Click here to view our video tutorial.
Click here to download our PDF tutorial.
Today, I will show you how to create a Home Inventory Template, in Excel 365. Let’s get started.
To start, click on File.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide2-1024x576.jpg)
On the right side of the home screen, click on more templates.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide3-1024x576.jpg)
In the search box on the left, type in Home Inventory. Hit enter, or click on the search icon.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide4-1024x576.jpg)
Excel will load several templates, for documenting your Home Inventory.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide5-1024x576.jpg)
Let’s click on the first one.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide6-1024x576.jpg)
In the window that opens, Excel tells you about this template and what it is best used for.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide7-1024x576.jpg)
You can use the left and right arrows, to scroll through the different Home Inventory templates. Each template will give you a brief description on what it can be used for.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide8-1024x576.jpg)
When you find the Home Inventory template that you like, click on create.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide9-1024x576.jpg)
Excel, will load your Home Inventory Template, ready for you to use.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide10-1024x576.jpg)
This template has a section to add your personal information, and the information of your insurance company.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide11-1024x576.jpg)
You also have an area, that shows all of your listed rooms, where the item was purchased, and if there is a photo available.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide12-1024x576.jpg)
To add a room, or a location an item was purchased. Click on the bottom row, to highlight it.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide13-1024x576.jpg)
Right click on the row, and choose, Insert.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide14-1024x576.jpg)
In the new row that appears. type in the new location, in the column for Room. And the new where purchased, in the column for Location Of Purchase.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide15-1024x576.jpg)
These new items, will automatically be added to the top right area, of your home inventory list.
![](https://marksexceltips.com/wp-content/uploads/2024/02/Slide16-1024x576.jpg)
View the Video Tutorial.
Download this tutorial in PDF by clicking the Download link below.