엑셀 틀고정Freeze first column
Choose View > Freeze Panes > Freeze First Column.
A faint line that appears between columns A and B shows that the first column is frozen.
Freeze the first two columns
Select the third column.
Choose View > Freeze Panes > Freeze Panes.
Freeze columns and rows
Select the cells to the right of the column and below the row that you want to remain visible as you scroll.
Choose View > Freeze Panes > Freeze Panes.
Go to View tab > Window > Unfreeze Frames.
reference:
If the View tab doesn’t appear, you may be using Excel Starter. Some features are not supported in Excel when launched.
You can always contact experts or get support from the Excel Tech Community.
Freeze panes to lock the first row or column in Excel 2016 for Mac
Split a window to lock rows or columns in separate worksheet areas
Formulas overview in Excel
How to prevent formula corruption
Find and fix errors in formulas
Shortcut keys in Excel
Excel functions (in alphabetical order)
Excel functions (by category)
Explore subscription benefits, find training courses, learn how to secure your devices, and more.
Microsoft 365 subscription benefits
Microsoft 365 Training
Microsoft Security
Accessibility Center
Our community allows you to ask and answer questions, provide feedback, and hear from knowledgeable experts.
Ask the Microsoft Community
Microsoft Tech Community
Windows Insider
Microsoft 365 Insider
