A Sheet(y) View, Improved

“Oh my goodness, that’s awesome!” said a fellow Building Level Team member when viewing the spreadsheet created from a Google Form. He was genuinely excited and surprised to find out that the data collected from the survey was automatically organized. Our BLT wanted to view individual responses, but since the default settings in a sheet are not ideal for that task, I made a few quick changes to improve the clarity. Knowing how you can (and that you can!) do the following in sheets will make your eyes smile.

  1. Freeze Rows or Columns
  2. Adjust column width
  3. Wrap text
  4. Show Summary of Responses/Explore (Automatically created Charts and Graphs! So magical.)

Use playlist button to switch between videos.

Leave a Reply