How to Properly Freeze Multiple Columns and or Rows using Freeze Panes in Excel
Professor Cubs Professor Cubs
3.21K subscribers
119 views
0

 Published On Mar 24, 2024

As most of you might know, using freeze panes in excel allows you to lock certain portions of your list on screen to make reading easier.

Freezing the top row, or first column is easy and straightforward, but freezing multiple rows and columns, or specific areas altogether, requires an additional bit of understanding how excel behaves when you use freeze panes.

By chance you are already familiar with freeze panes, and interested in the proper way- use the timestamps below to jump to the appropriate section of the video.

⌚ TIMESTAMPS
0:00 What is freeze panes in excel
0:26 First option: Freeze top row
1:13 Second option: Freeze first column
1:50 The "proper" way: Understanding the way excel freezes cells
4:00 How to freeze panes when your list is not in cell A1
4:33 Freeze panes challenge 1
5:09 Freeze panes challenge 2
5:38 Freeze panes recap

📢 FREE RESOURCES

Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...

Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...

☕ BUY ME A COFFEE?
https://www.buymeacoffee.com/professo...

show more

Share/Embed