Fix or freeze Excel row

Fix or freeze Excel row

Icon_Excel10_33x32Anyone who works on larger tables with Excel knows the problem.
When scrolling down, for example, the relevant information in the column description disappears from the field of view.
In the case of large tables, it is not always immediately apparent which value belongs to which column assignment.
With Excel it is easy to quickly fix the top line or several, so that they always remain visible even when scrolling.

 

Freeze the first row of a table:

Go to the tab in the ribbon OPINION.
Now click on Fix the window.
Then choose Fix the top line.
The first line is fixed and remains in the visible area when you scroll down.

 

Freeze / Freeze Excel Rows
Freeze / Freeze Excel Rows

 

Since it is not always the first line that remains visible, it is also possible to fix several lines.
In order for this to work, any already active fixation must be canceled under
View> Freeze Window> Unpin

If the first two lines are to remain visible, it is important to know that the first three lines must be marked for this.
The lines above the last marking are always fixed.
So the first three marked lines allow the first two lines to remain visible after fixing.
 

 

Freeze multiple lines:

For example, mark the first three lines to fix the first two
Now go to the tab in the ribbon OPINION.
Now click on Fix the window.
Then on the top line Fix the window.

Freeze Excel window
Freeze Excel window


The first two lines are fixed and remain in the visible area when you scroll down.
This works in the same way with columns.

Read / write comments

 (mh)

Transparency: This article may contain affiliate links. These lead directly to the provider. If a purchase is made through this, we receive a commission. There are no additional costs for you! These links help us to refinance the operation of win-tipps-tweaks.de.

___________________________________________________
This tip comes from www.win-tipps-tweaks.de
© Copyright Michael Hille

Warning:
Using Registry Editor or its tips incorrectly can cause serious system problems that may require you to reinstall your operating system. Tampering with the registry files and using the tips is at your own risk.