Q&A for How to Create an Inventory List in Excel

Return to Full Article

Coming soon

Add New Question

Question

How do i make labels of inventory items?

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

To make labels for your items, you'll need to either contact a 3rd-party labeling company or make your labels in-house. A 3rd-party labeling company is a good option if you have medium to high product volume and require professional labels. Making the labels manually is good for low volume production.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 3
Question

which will be the formula to know quantity limit to reorder and restock?

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

You can use the IF function in a new column to see when you need to reorder products. For example, IF([quantity] < [stock limit], "reorder", "don't reorder yet").

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 12
Question

Can I add a photo, video and map for each item?

Kyle Smith
wikiHow Technology Writer
Kyle Smith is a wikiHow Technology Writer, learning and sharing information about the latest technology. He has presented his research at multiple engineering conferences and is the writer and editor of hundreds of online electronics repair guides. Kyle received a BS in Industrial Engineering from Cal Poly, San Luis Obispo.

Kyle Smith

wikiHow Technology Writer

Expert Answer

You can add a photo and map using Insert > Illustration > Pictures > From Device. To add a video, you can add a link to an external video for reference.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 5
Question

Why should I format my text to wrap in Excel?

Community Answer

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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 10
Question

How do I freeze panes in Excel?

Sulaman Mubarak

Community Answer

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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 7