엑셀 틀고정 How to use Excel frame fixation: Naver Blog

엑셀 틀고정In Excel, if you have a table with countless rows and columns, you have no choice but to scroll the mouse to move down or sideways, and then scroll the mouse again to check which item the data in a specific cell belongs to. In this case, it is much more convenient to use Excel frame fixation.
When you click the View tab in the Excel menu, Excel frame fixation belongs to the Window group. So, from now on, the way to use Excel frame fixation is to fix the first row/first column, then fix a specific row/specific column, and finally fix it horizontally and vertically. I will explain it sequentially by dividing it into sections.

To freeze the first row, click Freeze Frame in the View menu and select Freeze First Row.

To freeze the first column, click Freeze Frame in the View menu and select Freeze First Column.

To fix a specific row, for example, if you want to fix a frame above row 5, select row 5 and then click Freeze Frame in the View menu and select Freeze Frame.

To fix a specific column, for example, if you want to fix a frame to the left of column C, select column C and then click Freeze Frame in the View menu and select Freeze Frame.

Lastly, to fix it horizontally and vertically based on cell C5, select cell C5 and then click Freeze Frame in the View menu and select Freeze Frame.
A driver’s license is a mandatory license that everyone must obtain. We provide information on the professional driver’s license academy near me, closest to where I am, and comprehensively evaluated by cost, price, reviews, etc. Driver’s license written test, driver’s license, driver’s license skills test, driver’s license test center, driver’s license academy, driver’s license road driving test, driver’s training, driver’s license written test application, driver’s license test, type 2 small license, type 1 large license, driving Class 1 ordinary license, driver’s license, driving school

엑셀 틀고정

하늘사랑