A recent update to Excel’s inventory template feature allows users to make their own inventory templates by selecting a type of Excel file and then opening it in Excel.
Users can then use the template to quickly create inventory items by clicking the arrow next to a cell or column and then dragging it to the desired location in the list.
With the new template feature, users will be able to make a spreadsheet or Excel spreadsheet template that is a snap to add to their existing workbook or workbook template, or to create a new inventory template to work with a template.
Users will be also able to create new Excel inventory templates that are more customizable than the existing Excel inventory options.
For example, users can change the amount of time that an item is listed on a list item, change the appearance of a cell in the Excel template, and make the template searchable by using search fields.
Users also can customize the template by adding text and images to the template.
Once created, users may save the template in a spreadsheet for quick use, or they can upload it to a service like Google Drive or Dropbox for easier access.
The new Excel template feature will be available in the new Excel 2013 and Excel 2016 versions of the Excel Online for Business product.