Create an overview in long tables by fixing important rows and columns. Thats how it works.
Enlarge
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:
-
Select the tab at the top of the menu ribbon
“Opinion”.
-
Click on the function there
“Fix window”.
-
Select from the drop-down menu
“Fix top line”
the end.
Enlarge
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
contiguous blocks
can fix, for example lines 1-3, but not lines 1 and 3. The brief instructions for this case are:
-
Select the row or column that comes below the block to be fixed. In our example: If you want to fix lines 1-7, you have to select line 8.
-
Switch to the tab again
“Opinion”
and open the drop-down menu at
“Fix window”.
-
There click on the first field of the same name
“Fix window”.
All rows or columns above or next to the selection area then remain visible.
Enlarge
Multiple rows or columns can also be fixed in Excel.
You can find more Excel topics here:
