So, if you scroll vertically or horizontally the range A1:B5 would remain fixed while the rest of the sheet’s content can move. Go to menu and select “Freeze cells -> Freeze rows and columns”Ĭalc would freeze all the sections left and top of the selection which is C6 in this example. Here’s how you can do it in LibreOffice Calc: Freeze When you are working with a spreadsheet and doing data analysis, it is often needed to freeze certain rows and columns while the rest of the section of the spreadsheet can move using scroll bars. There are different display devices, monitors available with various sizes and resolutions. So, this is why people make use of locking rows in Excel!Īfter all, you don’t want to spend an unnecessary amount of time searching for data when you could have it right in front of you at all times.This tutorial would explain how to Freeze, Unfreeze rows and columns, and ranges in LibreOffice calc. Scrolling for minutes at a time to try to compare two sets of data isn’t an efficient way of working.

This means that you’re still able to move the rest of the spreadsheet up or down or side to side. In short, freezing rows means that regardless of where you scroll in the sheet, the particular rows or columns that have been frozen always remain visible in the same place. One of the easiest ways to achieve this is to freeze a row (or column). For instance, this is particularly true when comparing two different sets of data that are nowhere near each other on your spreadsheet. However, there are ways of comparing data that make the process much smoother and generally less stressful.ĭepending on the task at hand, locking a row is a super handy tip to learn. When working with spreadsheets and a large amount of data, things can get complicated very quickly. In this article, I will explore how to lock rows in Excel. However, if you’re new to Excel, you might be wondering: How do you lock a row in Excel? If you don’t want anyone else to edit your data, then learning how to lock rows in Excel is essential.

Freeze first two rows in excel