Using simple formatting techniques Google Sheets users can create spreadsheets that are easier to read and more effective for viewing and display data. Working with spreadsheet data doesn’t have to be intimidating. As educators, we often need to collect, analyze and visualize data to truly understand trends in our classrooms, schools or districts. I’ve compiled some tips for Google Sheets newbies that will help you navigate sheets and make them easier to view.
- Alternating Colors: To increase the readability of data in a spreadsheet, turn on “Alternating colors” so that every other line is highlighted. Access this option by going to “Format” –> “Alternating Colors”. You can change the formatting style or create a custom style. Note: This option is also available through the “Explore” menu, which can be accessed by clicking the “Explore” icon at the bottom right corner of your spreadsheet page.
- Text Wrapping: A common issue with viewing information in a spreadsheet is the inability to see all of the information contained in a cell. This is particularly true when the cell contains text that could be many words or even several sentences. Turn on “Text Wrapping” to automatically adjust the cell height to accommodate information. Highlight the column (click on the letter at the top of the column) that contains the data you want to read. Click “Format” –> “Text Wrapping” –> “Wrap”.
- Freeze Rows / Columns: When scrolling through large sets of data, it can be helpful to freeze rows or columns that contain header information that you want to be able to see at all times. To freeze rows or columns, click “View” –> “Freeze” and make your selection.
- Conditional Formatting: To more quickly highlight data, such as low scores, you can set rules for conditional formatting, so that if certain criteria are met, cells in the spreadsheet will be highlighted in a color of your choosing. Highlight the range of data you want to apply the conditional formatting to, choose “
Sorting & Filtering
- Sorting data: Adjust the order that rows appear in your spreadsheet by sorting. Sorting allows you to keep your column headers in place and sort by multiple criteria. The important thing to remember about sorting is that you must select the RANGE you want to sort. Most often you want to sort ALL of the data in the spreadsheet. To do this, click the empty cell in the very top left corner of the spreadsheet to select the entire sheet. Choose “Data” –> “Sort Range” & choose the sort criteria you want to use.
- Filters: Using filters allows you to hide any data you don’t want to see. By enabling filters, you can easily click the filter icon at the top of any column and set the conditions you want for filtering to adjust what data you are viewing. Turn on filters by going to “Data” –> “Turn on Filter View”