Kick off the new school year with lessons from our Back to School 2021 collection to help students express themselves, build relationships, and stay organized.

3. Sheets: Format and Organize Spreadsheet Data — Use Bold and Italics, Merge Cells, Set Alignment, and Format Dates

Playback Speed:
Transcript

In the previous video, you created a duplicate copy of a sheet with data from a completed survey.

The data is organized with default headers and formatting.

It’s not necessarily easy to read, analyze, or see patterns in data that’s organized this way.

To make a spreadsheet easier to read, sort and understand, you might need to  change its headers and its format.

Even though much of the data is useful, some might be unnecessary.

To improve your spreadsheet, change the column headers so they’re easier for you to understand.

Rename the columns.

Then, insert two rows above the header row to create categories for your headings.

Categories help simplify your sheet headers and make the t-shirt orders easier to read and understand quickly.

Label each category.

These labels will be used to help you clearly see which types, sizes, and designs correspond to which t-shirt.

Update the rest of the headers for the first product.

Then copy the new headers and paste them in the rest of the cells.

Next, make your headers bold so they stand out.

Then, merge the cells in the row with your categories.

When you merge, you remove the dividing lines between cells.

Center align the text...

And adjust the number formatting in the date column to simplify your spreadsheet.

Then, move on to the next video to finish formatting your spreadsheet.

Instructions

  1. Insert new rows for category headers.
  2. Update the headers and make them bold.
  3. Merge cells.
  4. Adjust the date format.