Freeze and unblock rows or columns in Google Sheets

Content
  1. Works on mobile phones as well as computers and tablets
  2. Freeze a column or row on a computer
  3. Freeze a column or row on a smartphone or tablet

Works on mobile phones as well as computers and tablets

When working with a large spreadsheet, it can be useful to always see certain rows or columns. You may want the column headings to also show when you scroll down from the first page, or you may want to compare two rows of data that are far apart.

Whatever your motive, freezing (or unblocking) rows and columns in Google Sheets is very easy if you know which way to go.

Freeze a column or row on a computer

Follow these steps to freeze columns and/or rows in any major web browser, although Google Chrome is preferred. In this example, we’ll freeze the first row to show how it works when you scroll from the first row.

  1. Click Vision in the Sheets menu at the top of the screen. When the drop-down menu appears, hover over the option To freeze

  2. The following options are now displayed. Choose the one that suits your individual needs.
    Without lines: Unblock all rows
    1 line: Freeze the first row in your table
    2 lines: freezes the first two lines
    to the current line (x): freezes all rows up to the currently selected, represented by X
    Without columns: unblocks all columns
    1 column: freezes the first column in the spreadsheet
    2 columns: freezes the first two columns
    to the current line (x): freezes all columns up to the currently selected column displayed as X

  3. Then scroll horizontally or vertically. Note that the column or row you want to freeze will remain visible no matter where you are in the spreadsheet.

To unblock a column or row later, follow steps 1 and 2 again and select no lines or No columns

Freeze a column or row on a smartphone or tablet

Follow these instructions to freeze columns and/or rows on Android and iOS devices (iPad, iPhone, iPod touch).

  1. Launch the Google Sheets app.

  2. Open an existing spreadsheet or create a new one.

  3. Select the row or column you want to freeze by clicking it once so that it is highlighted as shown in the preview screenshot.

  4. Once selected, click it again to open the context menu.

  5. Choose an option To freeze or To freeze

  6. Then scroll horizontally or vertically. Note that the column or row you want to freeze will remain visible no matter where you are in the spreadsheet.

To unblock a column or row later, repeat steps 3 and 4 and select Unblock column or unblock row

Leave a Reply

Your email address will not be published.