So you can add a filter to show only yellow-colored cells in the data range. Click on the Sort & Filter tool just before the Find & Select tool. Select the Filter option from the dropdown.

Now, the dataset will display only rows 1, 4, and 5. Next, you need to highlight the visible rows. In Google Sheets, you may select visible cells by selecting individual ranges.Here’s how: ...

You can only freeze columns on the left side of the sheet. Steps to freeze rows and columns together in Excel. Select the cell below the row you wish to freeze and next to the column you want to ...