Create an overview in long tables by fixing important rows and columns. Thats how it works.
Freeze rows and columns in Excel
© Monticello / Shutterstock.com
Fixing rows and columns in Microsoft Excel makes it easier for you to keep an overview when scrolling tables or worksheets. What is meant is that the corresponding row or column “scrolls” or remains visible, so that you can always keep an eye on what the cells are about. Often this function is used to fix the first row (header), but the same can also be done for multiple rows / columns. We’ll show you step by step what to do.
Fix first line / header
The classic: You have a table with different titles in the first line and now want to fix it. How to do it:
If you fix the header, it remains visible when scrolling.
Fix the first column
Sometimes it can be useful to fix important data in the first column (A) if you have to scroll to the right more often in the worksheet. In this case, you do almost the same thing, that is
View> Freeze Window
and in this case
“Fix first column”.
Freeze multiple rows or columns
Freezing multiple rows or columns works a little differently. First of all, you should know that you only ever
can fix, for example lines 1-3, but not lines 1 and 3. The brief instructions for this case are:
Multiple rows or columns can also be fixed in Excel.
You can find more Excel topics here: