In this video, you'll learn more about how to highlight key data points in your spreadsheet. First, let's cover how to freeze or unfreeze rows and columns. To help us better view and navigate this document, we can choose to freeze important rows and columns so they remain visible as you scroll around the data set. Set your cursor where you want to put your freeze. Let's freeze the header title. So let's do this row. Open View, select Freeze and then we'll choose our row. Let's do a column too. It could make it easier for people to navigate data associated with movie titles if we make this column frozen. That way, this column will also be in view no matter how far to the right there looking. So you can always see what movie the data is referring to. Now you know how to freeze and unfreeze rows and columns. Moving on. Let's showcase how to hide or show rows and columns. So why would you want to do that? Well, it might not be essential for you to show all your data all the time, you might be working with a huge data set. So sheets gives us the option to hide data in our spreadsheets. For example, let's say we didn't need all this information about the cast. Choose the column you want to hide. Right-click the column selection to show us our options and we're going to select Hide columns. We can do the same thing with rows. Right click on the row to show us our choices and select Hide row. We'll find this visual indicator here that a row has been hidden. It's easier to expand this data and show it again, just click right here. Next step, let's go over how to resize rows and columns. The data you put in each cell might come in different sizes or lengths and sometimes it's nice to format things to reflect that. Often, this trick can help make your spreadsheet look more organized. We can quickly resize a row by simply double-clicking on the row we want to resize. So this automatically expand the rows, so the content fits perfectly nice. We can use the same technique with columns. Just double-click on the column that you want to resize. This will automatically adapt the width so all content shows. Easy. You can manually adjust the width of a row or column as well. Right-click on a row to see the options. Well, select Resize column or Resize row. Here, we can either choose to fit to data or we can manually set a pixel count. That's it for resizing. Now let's talk about a group rows and columns. Sometimes we want to collapse different areas so the spreadsheet is easier to navigate. For example, let's select the directors columns. So right-click to open our options. Select group columns together. This will create a gap in the grid to notify a group column has been created. Using this visual indicator, you can choose to expand and show the content again if you want. Let's use colors and borders to style things. Making borders around certain cells and even changing its colors do the trick really well. We can customize the spreadsheet with all sorts of different fill colors and text colors. Open Borders, choose which type of border you want to apply, customize the border color and border-style. Let's border one of our tables. What's the banding feature and how could we use it to group data? When I'm working with large data sets, altering the colors sometimes helped me view certain sections of it more easily. Another term for banding would be to alternate column or row colors. So let's show this one off. Select the first cell on this row and this column. Let's open Format and select Alternating colors. Now we can see different color options and customization options, that's nice. You can choose from the default styles. Let's pick a color. There we go. Hit ''Done''. All right. In this video, you learned how to freeze and unfreeze columns and rows, how to hide and show columns and rows, how to resize columns and rows, split text to columns, use colors and borders for styling and how to group data using the banding feature. Nice work. In the next video, we'll cover how to enter objects in your spreadsheet.
