Using Excel For Recipes

New Popular Recipes

Frequently Asked Questions

How do I create a recipe spreadsheet?

To begin, open a blank workbook in Excel. Make sure your recipes are accessible and decide how much information you want in your recipe spreadsheet. If you have printed recipes, whether on recipe cards, cut from magazines or any other type of hard-copy recipes, and you have a computer scanner, upload the recipes to your computer before you begin.

How do I use a recipe template?

Recipe Template Set-up. The best way to use a recipe template is to set it up with all the basic info you want to appear on all your recipes, such as restaurant name, chef’s name, etc. Save it as “Recipe Template“. When you want to create a new recipe, open the “Recipe Template” file and immediately “save as” the name of your new recipe.

How do I find recipes in Excel weekly meal planner?

To find more recipes, you can look through your collection of cookbooks, or go to the Recipes sheet in the Excel Weekly Meal Planner. On the Recipes sheet, enter an ingredient name in cell A2, then click the Get Recipes button. A macro runs, and pulls a list of recipes for the selected ingredient. To see one of the recipes, click its link.

How do I create a new recipe?

When you want to create a new recipe, open the “Recipe Template” file and immediately “save as” the name of your new recipe. Then add all of the content for your new recipe. This will keep your template blank and clear so it will be easy to use repeatedly. Do not open your template, add all the content for your new recipe, and simply click “save”.

Most Popular Search