Freeze Panes in Excel will lock rows or columns or both. It is a necessity when you have a large worksheet. To freeze your header row, click one row below it, go to the View Tab and click Freeze Panes - then click Freeze Panes again. To unfreeze, you can be anywhere in your worksheet. To freeze columns, when you have a lot of columns and need to scroll to the right, click the column to the right of the last column to freeze, click the View tab, click Freeze Panes, and click Freeze Panes again. To freeze both columns and rows, click a cell. The cell will be in the row you want to freeze and the column you want to freeze.
Chapters:
0:00 Intro
0:15 Freeze panes - rows
1:10 Unfreeze panes
1:28 Freeze panes - columns
1:50 Freeze panes - both columns and rows
2:40 Table - automatic freezing
#msexcel #chrismenardtraining #microsoftexcel #exceltraining
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
Excel Freeze Panes - Freeze panes to lock rows and columns
Теги
freeze panesmicrosoft excelfreeze panes in excelfreeze panes in excel column and rowexcel freeze panesexcel tutorialfreeze columns and rows in excelexcel freeze both columns and rowschris menardchris menard trainingchris menard exceltraining with chris menardexcel freeze panes both rows and columnsExcel Freeze Panes - Freeze columnsFreeze rowsFreeze columns and rowsexcel lock columnsexcel lock rowsexcel lock columns and rows