How to Freeze Multiple Rrows or Columns in Google Sheets

How to freeze a row or column in Google Sheets

Learn how to freeze multiple rows or columns in Google Sheets to keep important headers and labels visible as you scroll.

  1. Open Google Sheets:
    ◉Open your Google Sheets document.
  2. Select Rows or Columns to Freeze:
    ◉Click on the row number or column letter you want to freeze.
    ◉To freeze multiple rows, click and drag to select the rows. Similarly, do the same for columns.
  3. Access the Freeze Menu:
    ◉Click on the “View” menu at the top of the screen.
    ◉Hover over “Freeze” in the dropdown menu.
  4. Choose Rows or Columns to Freeze:
    ◉Select “Up to current row” or “Up to current column” to freeze the selected rows or columns.
    ◉You can also choose pre-set options like “1 row,” “2 rows,” “1 column,” or “2 columns.”
  5. Verify Freezing:
    ◉Scroll through your sheet to see if the selected rows or columns remain fixed at the top or left side of the screen.

By following these steps, you can easily freeze multiple rows or columns in Google Sheets to keep important information visible while you scroll. Watch the tutorial for a quick guide!