How to Properly Freeze Multiple Columns and or Rows using Freeze Panes in Excel
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...
Смотрите видео How to Properly Freeze Multiple Columns and or Rows using Freeze Panes in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 24 Март 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 141 раз и оно понравилось 12 людям.