Ask Your Question

How do I lock (FREEZE) a row of cells in Calc? [closed]

asked 2014-08-07 11:33:59 +0200

DerekNW gravatar image

updated 2020-10-30 15:13:33 +0200

Alex Kemp gravatar image

I want to set a row as a sub-heading by locking them, so that they appear at the top of the sheet, regardless of where in the sheet I am working or viewing. How can I do this? There are no indications in any of the menus or the built-in help.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-04-11 20:53:52.472185

3 Answers

Sort by » oldest newest most voted

answered 2014-08-07 12:23:18 +0200

Lupp gravatar image

updated 2016-03-02 21:57:20 +0200

Editing 2016-02-27:
Please note the comment by @dabisu. Starting with version 5.1 a new campaign of reworking the menu structure with respect to clarity and usablility has reached the surface. See also this thread in the other forum and the there linked in sources. End edit

This makes sense only if the "heading" stays in place above the headed columns. If you want them shown also while doing something much more to the right (higher column numbers) in the sheet you will have to fix the complete columns.

Fixing rows and or columns is only possible for the topmost/leftmost rows/columns. It can be done by selecting the first cell below/right of the rows/columns to fix and then mark the submenu item 'Window' > 'Freeze' checked.

Example1: You want to only freeze the rows 1 through 3: Select A4, > 'Window' > 'Freeze'

Example2: You want to only freeze the first coluimn: Select B1, > 'Window' > 'Freeze'

Example3: You want to freeze the first column AND the topmost 5 rows: Select B6, > 'Window' > 'Freeze'

Horizontal splitting can also be done by dragging the splitter above the vertical scroll bar. it's only available as long as NO FREEZE is active. Vertical spliiting: The splitter is placed right of the horizontal scroll bar.

edit flag offensive delete link more



This answer is not longer valid. The "Freeze" is in the menu "View", not "Window".

dabisu gravatar imagedabisu ( 2016-02-27 04:29:45 +0200 )edit

Not in my version it isn't - It's in the 'Window' menu. V5.0.5.2

MikeN gravatar imageMikeN ( 2016-03-01 08:21:41 +0200 )edit

@MikeN: I stated "Starting with 5.1" on 2016-02-27..

Lupp gravatar imageLupp ( 2016-03-02 13:52:46 +0200 )edit

I realise that but I was responding to your statement 'This answer is no longer valid'. It is still perfectly valid for hundreds of thousands of users who use v5.0.5.2 or earlier. Not everyone can get 5.1.

MikeN gravatar imageMikeN ( 2016-03-02 16:25:12 +0200 )edit

"clarity and usability" is not "select the row below the one you want to freeze"; both Excel and Google Sheets say to select the row you want to freeze, which is actual "clarity and usability"

daveqeh gravatar imagedaveqeh ( 2016-06-29 22:02:37 +0200 )edit

@deveqeh: I do neither use 'Excel' (which one) nor 'Google Sheets' (and I am not a developer). I just want to state that 'Freeze' does not exclusively apply to rows but also to columns. For Calc (V5.1.2) I can tell you: "If you have selected a single cell, > 'View' > 'Freeze Rows and Columns' will split the sheet area, the selected cell being topmost leftmost in the right bottom part. The freeze will apply to rows above and columns left of it. How will you describe Excel's behaviour?

Lupp gravatar imageLupp ( 2016-06-30 00:03:20 +0200 )edit

answered 2016-04-22 17:41:26 +0200

MarjaE gravatar image

updated 2016-04-22 17:46:08 +0200

Freeze doesn't work in

First, the selection method is counterintuitive. Second, after sorting that out, it still doesn't work. If you select all and sort your table, it will scramble the title row into the table, frozen or not.

edit flag offensive delete link more



Sorry. I do not understand. How comes sorting into this business? Freezing split series of columns/rows for the view did never exclude them from sorting. 'Select All' is not a common step of preparing a sort operation.
Concerning the question what method to indicate the columns/rows to 'Freeze' would be the most intuitive I cannot find one obviously better leading the flock. You may, however, use the vertical and/or horizontal splitters in advance of freezing.

Lupp gravatar imageLupp ( 2016-04-22 21:38:45 +0200 )edit

Does not work in either.

Maestro2711 gravatar imageMaestro2711 ( 2017-07-02 21:44:36 +0200 )edit

I am using since it was released. I cannot confirm this claim.

Lupp gravatar imageLupp ( 2017-07-02 23:04:24 +0200 )edit

answered 2018-02-16 19:06:06 +0200

JO'DONNELL gravatar image

We had the top 7 rows frozen in one spreadshead file. We installed the latest edition, 6 something, and it still worked, however when we tried to reset it for the top 8 rows to be frozen it would not freeze and the previous 7 rows were no longer frozen. We were unable to go basck to how it was set up so now we no longer have the top section frozen. Freezing in view or clicking the row icon at the top no longer works. Since updating to 6 we also find that if we have calc, base and or writer files in the back ground with Google at the front and we wish to go to Calc etc, when we click the calc icon in the task bar nothing happens. we have to minimise Google first to get Office at the front In Calcs we can no longer set a data base for colums etc as we did in Excel.

edit flag offensive delete link more


To freeze the first 7 rows you place the cell cursor on A8 and select menu View → Freeze Cells → Freeze Rows and Columns. The rest with "Google at the front" is completely unrelated to this topic.

erAck gravatar imageerAck ( 2018-02-16 19:32:10 +0200 )edit

Question Tools



Asked: 2014-08-07 11:33:59 +0200

Seen: 47,998 times

Last updated: Feb 16 '18