Freezing selected rows, columns together

[iddqd]

Hi everyone,

Can somebody help me locking 1st row and E,F,G columns so they would remain where they are when scrolling upp and down.

thanks

[PKG]

Freezing Rows or Columns as Headers

[iddqd]

thanks for replaying. i tried that. it freezes 1st row but doesn’t freeze E,F, G columns.

now i found 2 solutions while i type.

A-libreoffice seems only freezing 1st row and 1st column. but not another column? (i would be more than happy i am wrong on this. i appreciate any corrections) so i could move my calculations to the 1st column. i can do this.

B-I could sort my main data tables in DESCENDING ORDER so the the E,F,G columns would remain static. i am going to do this.

thanks for the reply PKG

[robleyd]

Consider moving columns E-G to A-C, then you can freeze row 1 and columns A-C

[iddqd]

i just tried that but it doesn’t seem doing it.

i really don’t understand why i can’t freeze a column at all. freezing rows is simple. move the little seperator above the vertical scroll bar to whereever you want and it freezes anything above it.

i do the same on horizontal seperator and has no effect when scrolling up and down. all columns move up and down expect the rows i froze earlier.

note: now i realized that i was actually looking something like “scroll lock” as cells has data outside your view can be seen via scrolling with wheel of your mouse. i see.

now i revise my question.

"how do i disable scrolling in some columns or cells?

[iddqd]

it’s clear that i was thinking all wrong. freeze doesn’t mean “freeze to navigate.”
when frozen, selected rows don’t move up and down and when froze a column it doesn’t move left and right.

i only wanted one portion of the screen to be navigate able using mouse or keyboard. which the area i added new data.

do you know anything about this? if exists?

[Hrbrgr]

@iddqd

i only wanted one portion of the screen to be navigate

Try View > Split window. Drag the marker (small grey bar) for splitting from the end of the scroll bar to the middle. If you split horizontally and vertically, you will have 4 separate areas.

---

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded

[iddqd]

will do. thank you.

[LeroyG]

You can rearrange the totals to put them in the first 9 rows of columns A:C; then you can freeze until row 10.