Freeze Rows and Columns in Google Sheets

Topic

New Reply

[WSJon5]

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 1 year, 3 months ago by WSJon5.

Reply | Quote

Replies

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.

WSJon5

Reply | Quote

Thanks, Samak! Unmerging those cells did the trick. All the best, J

Reply | Quote