엑셀 틀고정This is mainly used when you want to lock only specific rows or columns in order to view them while scrolling in Excel.
Run it in the following order: “View tab – Window panel – Freeze frame – Freeze first row (R).”
excel-first-row-fixed
Excel-Row-Fix-Example 1
Only the first row is fixed, so if you scroll down, the fixed first row will continue to be exposed.
Execute in the following order: “Click with the mouse on the row to be fixed – View tab – Window panel – Freeze frame – Freeze frame (F)”.
Example) If you select row 7 and select freeze frame (F) as shown in the photo below, rows 1 to 6 will be fixed.
excel-row-freeze
Excel-Row-Fix-Example 2
As in the example, if you point the mouse to a cell in row 7 and fix the frame, you will see that up to row 6 is fixed and the fixed value is exposed even when you scroll down. You can use this method when fixing multiple rows.
Execute in the following order: “View tab – Window panel – Freeze frame – Freeze first column (C)”.
excel-first-column-fixed
Excel-column-fixed-example 1
As shown in the photo above, only the first column is fixed, so even if you scroll to the side, the fixed first column continues to be exposed.
Click with the mouse on the column to be fixed – View tab – Window panel – Freeze frame – Freeze frame (F).
Example) As shown in the photo below, if you select column C and then select freeze frame (F), columns A to B will be fixed.
excel-column-freeze
Excel-column-fixed-example 2
As in the example, if you point the mouse to a cell in column C and fix the frame, you will see that column B is fixed and the fixed value is exposed even if you scroll to the side. Just like pinning rows, you can use this method when pinning multiple columns.
If you want to unfreeze the frame in the same way as how you fixed the frame, go to “View tab – Window panel – Freeze frame – Unfreeze frame (F)” to unfreeze the frame.
This article covers how to freeze frames in Excel. It’s a short article, but I hope it helps. thank you
Designed by Tistory
© Kakao Corp.
