엑셀 틀고정If there is a lot of data in Excel, you can make a specific title row visible regardless of the area. It’s called Freeze Panes in Excel and there are three options, so let’s take a look at them all.
This post is about fixing the frame of the Excel ribbon view tab.
72Practice file.xlsx
72Practice file_completed version.xlsx
This is the most common form of frame pinning, and only the first row is fixed so that the first title row remains visible even when the mouse is scrolled down.
When the frame is fixed, the title of the first line is displayed as is, even though the mouse scrolls to 114 lines.
This is a feature I personally use often, and when entering homework scores by name, if the homework number goes beyond column 22, it becomes difficult to tell who is who. At this time, it is often used to check the name at any location by fixing the first column.
When you fix the first column, the first column, application name, is fixed.
When creating an Excel data sheet, the first row or first column is often not used as the title. In this case, you can fix the desired part at any time by fixing the frame manually.
When fixing a frame, the frame is cut to the left and upward based on the cursor where the self-cursor is located. And that part is fixed.
No matter where you go, columns A, B, C and rows 1, 2, 3, 4, and 5 are visible.
small
quantity
If it’s data
mouse
scroll
comfortable
capital
Although there is
Likewise
data
700 rows
If you pass by
especially
line
fixed
very
usefully
It is used.
