2. Select a Recipe and Set Up Your Spreadsheet

Playback Speed:

In this video, you will select a recipe and add column headings to your spreadsheet for the recipe information.

To begin, select the recipe you would like to adjust.

You can search the internet for a recipe, use your own recipe from a cookbook or other source, or use one your teacher gives you.

Type the name of your recipe at the top of your spreadsheet.

Bold the recipe title and increase the font size to make it stand out.

To increase or decrease the number of servings in your recipe, you will first need to find the number of servings the original recipe makes.

Servings refers to how many people the recipe is expected to feed.

Create a column heading for servings in your spreadsheet.

Column headings go at the top of columns and describe the information the column contains.

Every recipe has a list of ingredients...

the quantities you need to make the dish...

and instructions for how you put those ingredients together.

Create a column heading for the ingredients in your spreadsheet.

Next, to figure out how much of each ingredient you will need to adjust the recipe, you will have to record the quantities of each ingredient needed to make the original recipe.

Add a column heading for the quantities.

Then add a column heading for the related unit of measure, such as cups or teaspoons.

Bold your column headings and add shading to make your spreadsheet easier to read.

Then freeze the rows that contain your recipe title and column headings.

Freezing these rows will allow you to still see them if you have to scroll down through a long list of ingredients.


  1. Select a recipe and add the title to your spreadsheet.
  2. Format the title.
  3. Add column headings for servings, ingredient, quantity, and unit of measure.
  4. Bold the column headings and add shading,
  5. Freeze the rows with the title and headings.