Skip to content
Looking for lesson ideas? Check out our new Back to School 2020 collection to keep students engaged whether learning remotely or in the classroom.

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

Playback Speed:

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. In this video, you will: Change the column headers, Create categories, Format the headers and categories, Merge cells, And adjust the date formatting.

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. Now, it’s your turn: Insert new rows for category headers, Update the headers and make them bold, Merge cells, And adjust the date format.


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