Skip to content
Playback Speed:
Transcript

In this video, you will set up your spreadsheet to organize your seasonal activity planner.

You’ll organize your spreadsheet with activity detail categories. When you learn about a new activity, you can easily add the details to your spreadsheet, such as the date, time, and location.

Spreadsheets are made up of rectangles called cells.

A cell is a place where you enter information.

Cells are organized into rows and columns.

A row is a horizontal set of cells and is labeled with a number.

A column is a vertical set of cells and is labeled with a letter.

Every cell has an address, based on its column and row. For example, this cell is called A1, because it is in column A, row 1. This cell is B3, or column B, row 3.

To begin, rename the sheet on the spreadsheet tab. Use a name that will identify the season.

Naming your sheet can help you stay organized, especially if you decide to add additional sheets later on to organize activities for other seasons.

Next, create column headings to organize your activity details.These headings will help you keep track of your activities and the important details you’ll need to know about each one.

You may also want to add column labels for activity cost, notes about the activity, or anything else that might be useful for your own planning.

Bold the first row, so that the categories will stand out separately from the activities.

Align the text to center it.

Then, add a background color to the row.

If you use a dark color, consider changing the text to white.

Now, select the entire sheet to wrap the text.

Wrapping makes text visible and makes sure it does not get clipped or cut off.

Finally, increase the width of the columns to make it easier to read all of your information.

Wrapping text and increasing the width of the columns is important later when you begin adding activity details to your spreadsheet. You can always adjust the width again when you add more information, if you need to.

Now, it’s your turn: Rename the sheet to identify the season, Label the columns, Bold the first row and align the text, Add a background color, and change the color of the text if necessary, And wrap the entire sheet and increase the width of the columns.

Next

Instructions

  1. Rename the sheet to identify the season.
  2. Label the columns.
  3. Bold the first row and align the text.
  4. Add a background color, and change the color of the text if necessary.
  5. Wrap the entire sheet and increase the width of the columns.