Do you ever want to find out about how many calories are in the meals that you’re eating every day or the nutrition that you are getting from the food intake into your body? The best option that you can use to find out about foods is to use the Food data type in Microsoft Excel.
How to use Food Data Type in Microsoft Excel
Follow the steps below on how to use the Food Data Type in Microsoft Excel to get calorie & nutrition facts:
- Launch Excel spreadsheet
- Highlight the cells of the Food you want to look up.
- Click the Data tab and select the Food data type from the Data Types gallery.
- Click the Insert Data button on the right side of the cell & select an option from the menu.
- Whatever option you have selected will appear adjacent to the selected cells.
Create a table head titled Breakfast and Cholesterol.
Add some food names under Breakfast.
Highlight the cells under Breakfast.
Click the Data tab and select the Food data type from the Data Types gallery.
Click the Insert Data button on the right side of the cell.
Scroll down and select Cholesterol from the menu.
You will see how many Cholesterols these foods contain.
You can select the Show Card button or press Ctrl + Shift +F5 to display showcasing a menu that gives info about the selected food or foods.
What are the Data Types in MS Excel?
There are four Data Types in Excel – Number, Text, Logical and Error data.
What type of data is food?
The Food data type converts cells with food to nutrition facts. The Food data type is powered by Wolfram, and you can select the info about the type of nutritional information you want to find.
Read: How to use the TAN function in Microsoft Excel
What is Data menu in Excel?
The Data menu contains many important features in Excel to manipulate data in your spreadsheet; it includes features to import and add connections to the database, sort and filter data, data validation, forecast, and more.
We hope this tutorial helps you understand how to use Food data type in Microsoft Excel; if you have questions about the tutorial, let us know in the comments.