[Solved] How to keep first rows frozen?

RobKdude · Post by **RobKdude** » Mon May 03, 2010 7:13 pm

Hi. I just saw a Calc file with the first row seemingly "frozen" at the top of the page. Even when the user scrolls down and the number 1 row remains at the top. This is an excellent feature and I have sought to find it in the past but have no idea what it is called. Any help or just a point in the right directin would be most appreciated. Thanks in advance to anyone available.

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

Post by **acknak** » Mon May 03, 2010 7:15 pm

Select the row below the one you want to freeze, then do Window > Freeze.

So, if you want to freeze the first row, select row two, and use the menu: Window > Freeze.

RobKdude · Post by **RobKdude** » Mon May 03, 2010 7:38 pm

Acknak,
Thanks for the Quick Reply, brother. Do you know if it possible to freeze multiple rows or am I pushing my luck? (For example row 1, 2 and 3)

Post by **RoryOF** » Mon May 03, 2010 7:40 pm

Try it and see! Also works on columns.

RobKdude · Post by **RobKdude** » Mon May 03, 2010 8:17 pm

Thanks, Rory and Acknak. FANTASTIC! I always wanted to do that! Very helpful =)

Rocinante · Post by **Rocinante** » Tue Jun 23, 2015 9:08 pm

So not intuitive.

Post by **RoryOF** » Tue Jun 23, 2015 9:10 pm

There is a most useful invention called the Help file.

juriaan · Post by **juriaan** » Mon Oct 05, 2015 5:01 pm

Selecting the second row to freeze the top row, is a bad solution for at least two reasons:
1. it is the opposite of intuitive, not many will do this without scanning through fora like this
2. it simply doesn't work when using a filter that exclude the 2nd row

I think the ability to freeze the top column in a spreadsheet is rather basic funcitonality that should be present
Regards

LotBlind · Post by **LotBlind** » Sat Oct 22, 2016 11:22 am

Agree that this is counterintuitive: it should freeze what you've selected, not what's above it. If you select just one row/column in the middle, I suppose it should interpret as freezing everything to the left/above.

Post by **RoryOF** » Sat Oct 22, 2016 12:11 pm

LotBlind wrote:Agree that this is counterintuitive: it should freeze what you've selected, not what's above it. If you select just one row/column in the middle, I suppose it should interpret as freezing everything to the left/above.

Which is exactly what it does.

LotBlind · Post by **LotBlind** » Sat Oct 22, 2016 1:34 pm

Okay, I didn't test that, I was just thinking aloud. But the first part stands - I selected by intuition the 1st row but nothing happened.

[Solved] How to keep first rows frozen?

[Solved] How to keep first rows frozen?

Re: Humble request for help

Re: Humble request for help

Re: Humble request for help

Re: Humble request for help

Re: [Solved] How to keep first rows frozen?

Re: [Solved] How to keep first rows frozen?

Re: [Solved] How to keep first rows frozen?

Re: [Solved] How to keep first rows frozen?

Re: [Solved] How to keep first rows frozen?

Re: [Solved] How to keep first rows frozen?