Tech

Excel: fix rows and columns – this is how it works






Create an overview in long tables by fixing important rows and columns. Thats how it works.

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:

  1. Select the tab at the top of the menu ribbon

    “Opinion”.

  2. Click on the function there

    “Fix window”.

  3. Select from the drop-down menu

    “Fix top line”

    the end.

If you fix the header, it remains visible when scrolling.

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:

  1. 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.

  2. Switch to the tab again

    “Opinion”

    and open the drop-down menu at

    “Fix window”.

  3. 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.

Multiple rows or columns can also be fixed in Excel.

Enlarge

Multiple rows or columns can also be fixed in Excel.

You can find more Excel topics here:

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button