• Freeze Rows and Columns in Google Sheets

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Freeze Rows and Columns in Google Sheets

    Author
    Topic
    #2636555

    Hi folks,

    I need your help. Please take a look at this Google Sheet.

    1. Rows 1-4
    I’d like to freeze rows 1-4, but I can’t find an option to freeze “up to row 4” — View/Freeze presents only “No rows,” “1 row,” “2 rows,” or “Up to row 8.”

    In fact, clicking on any of these otpions (except, of course, “no rows”) produces the following error:

    “Sorry, you can’t freeze rows which contain only part of a merged cell. Try to break apart merged cells or freeze more rows to include the complete merged cells.”

    Any idea how to do this? It seems that I need to reconfigure, or at least tweak, my formatting.

    2. Column 1
    I’d like to freeze column 1, but here, too, I get the same error:

    “Sorry, you can’t freeze columns which contain only part of a merged cell. Try to break apart merged cells or freeze more columns to include the complete merged cells.”

    Any creative solutions? I’m stumped.

    Thanks so much!

    • This topic was modified 2 weeks, 3 days ago by WSJon5.
    Viewing 0 reply threads
    Author
    Replies
    • #2636648

      Cells A1 to K3 appear to be merged. As it says, unmerge them.

      Then you should be able to freeze column 1.

      If there really is no way to select only 4 rows to freeze (it sounds unlikely to me but I don’t use Google Sheets), you could probably add 4 more rows after row 3 making the old row 4 now row 8. Then hide those 4 new rows and select freeze “Up to row 8.”

      Others here may have a more elegant solution.

      HTH

      Windows 10 Home 22H2, Acer Aspire TC-1660 desktop + LibreOffice, non-techie

      1 user thanked author for this post.
    Viewing 0 reply threads
    Reply To: Freeze Rows and Columns in Google Sheets

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: