Ask Your Question

How freeze both (multiple number) of row and columns

asked 2018-03-28 19:37:58 +0100

Griff ONline gravatar image

How freeze both (multiple number) of row and columns I want to freeze two or more top rows AND two or more columns ... this AND is in capital because my libre office keeps unfreezing the frozen row when i choose freeze first column and keeps unfreezing the frozen column when i choose freeze first row. So i cant freeze both top and bottom rows and cant freeze more than one it only allows for freezing the top first row. Please help I am trying to find a cheaper solution for college and we all know college students have no money.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-03-28 21:51:47 +0100

jaragon gravatar image

Put your cursor on the uppermost and leftmost cell that you don't want frozen. So, if you want to freeze the first three rows (1, 2, and 3) and the leftmost two columns (A and B), put your cursor in cell C4. Select "View" > "Freeze Cells" > "Freeze Cells and Columns."

edit flag offensive delete link more


As an ammendment to @jaragon ans -The question mentioned freezing both top & bottom row. This can't be done as freezing. However you can do a split screen for the bottom row being displayed. You can split columns & rows so choose what is wanted. To just split top & bottom, select a cell in column A & a row where you want the split to occur. Then from menu select View->Split Window. Top & bottom scroll independently so you can always have bottom show last row(s). Selection again to turn off.

Ratslinger gravatar imageRatslinger ( 2018-03-28 22:06:17 +0100 )edit

Thank you @jaragon your answer did fix my issue, I am new to this upvote-ing thing and useing forums. The website says that I have to have 5 points before I can cast a vote in order to up vote your answer, but thank you... also thank you to @Ratslinger even though I have not tried your comment fix yet I will look into it.

Griff ONline gravatar imageGriff ONline ( 2018-04-16 21:10:35 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-28 19:37:58 +0100

Seen: 512 times

Last updated: Mar 28 '18