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.
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.
This answer is not longer valid. The “Freeze” is in the menu “View”, not “Window”.
Not in my version it isn’t - It’s in the ‘Window’ menu. V5.0.5.2
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.
“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”
@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?
Freeze doesn’t work in 5.1.1.3.
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.
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.
Does not work in 5.3.3.2 either.
I am using 5.3.3.2 since it was released. I cannot confirm this claim.
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.
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.