How to Lock Rows and Columns Using Freeze Panes
This video explains how to lock rows and columns in a large Excel data set so you can still see table headers or specific columns when scrolling down or sideways. This feature is called Freeze Panes.
EXERCISE FILE
⬇️ Free download here: https://docs.google.com/spreadsheets/...
EXCEL E-BOOK PRICE IS YOURS
🎓 Learn Excel from Scratch E-book https://lynk.id/ignasiusryan/D8p04vG
📊 72 Excel Formulas E-book https://lynk.id/ignasiusryan/kKgPP4W
🏎️ 100 Important Shortcuts E-book https://lynk.id/ignasiusryan/DAabpz5
GET IN TOUCH
📷 Instagram / ignasiusryan
✈️ Telegram https://t.me/ignasiusryan
📽️ TikTok / ignasiusryan
🌐 Website https://linktr.ee/ignasiusryan
📧 Email: [email protected]
I use Excel 365.
If you found this video helpful, please subscribe so you don't miss my other videos and help share it with others. Who knows, this might be the video they've been looking for.
Thanks,
Igna
You're so cool, you read the description of this video all the way to the end.
00:00 Intro
01:30 Locking the Topmost Row
02:20 Locking the Leftmost Column
03:45 Locking Rows and Columns in Specific Cells
07:10 Unfreezing Panes