Playback Speed:
Transcript

In a digital spreadsheet, you can quickly navigate rows, columns and cells to add and update information.

That’s useful when you are trying to plan meals during a busy day or week.

In this video, you will create headings, or category names, for the days of the week and mealtimes in your spreadsheet.

To start, name your sheet with the date of the week your meal plan will begin.

Add the first day of your week.

You might choose to start your week on Sunday, especially if that’s the day you update your meal plan.

Then, create headings for the remaining days of the week by grabbing the fill handle and dragging it down 6 rows.

Bold your headings to make them stand out.

Next, choose which mealtimes you will include in your meal plan.

Individual schedules may vary and you might not eat all your meals together as a family.

That’s okay.

It’s still useful to plan for breakfast, lunch, and dinner, so that a meal is available for those who will eat at that time.

Create a column heading for breakfast.

Then, skip a cell in your heading row and add a column heading for lunch.

Skip another cell in your heading row and add a dinner column heading.

Add subheadings to your columns for the meal you will plan, and the cook who will prepare it.

A subheading divides your heading into specific categories.

Next, merge the cells for your column headings.

Merging combines 2 or more cells into 1 which is especially useful if you have more than one sub-heading to add below your heading.

And format the titles so they are aligned over your subheadings and stand out.

Instructions

  1. Add headings for days of the week.
  2. Create headings for mealtimes.
  3. Add subheadings for the type of meal and the person who will cook.
  4. Align and format your headings and subheadings.