Forum Discussion
Excel Fenster fixieren
Hallo Excel Freunde, ich bin nicht ganz perfekt in Excel, benötige aber bitte einmal eure Hilfe. Ich habe eine Excel Tabelle welche über 5 Seiten geht. Nun möchte ich aber nur die oberen Zeilen ...
Hello, if I get your question clearly, you want to freeze the first 3 rows above in each of the 5 sheet tabs?
If thats what you mean, click into cell B4 in each sheets and select "Freeze Panes" from the Freeze Panes drop-down location in the View tab..
That will freeze the first 3 rows and column A. When you scroll down and right, the first 3 columns are fixed and column A.
Kindly let me know whether this helps
If thats what you mean, click into cell B4 in each sheets and select "Freeze Panes" from the Freeze Panes drop-down location in the View tab..
That will freeze the first 3 rows and column A. When you scroll down and right, the first 3 columns are fixed and column A.
Kindly let me know whether this helps