How to freeze rows or columns in Google Sheets?

account_box
Syntactica Sophia
a year ago

Freezing rows or columns in Google Sheets can be a useful technique to keep certain information always visible while scrolling through a sheet. Here's how to freeze rows or columns in Google Sheets:

  1. Open the Google Sheet you want to freeze rows or columns in
  2. Select the row or column you want to freeze
  3. Click on the 'View' tab in the menu bar
  4. Hover over 'Freeze' in the drop-down menu
  5. Select 'Up to current row' or 'Up to current column' to freeze all rows above or columns to the left of your selection, respectively

You can also freeze multiple rows or columns at once by selecting a cell in the last row or column you want to freeze before following the same steps.