Locking Columns Advanced
There is an Excel file that teaches how to perform the Locking Columns Advanced operation.
Excel-Based Locking Columns Advanced
This workbook demonstrates locking columns advanced using VBA macros on a 618-row data layout.
Hope it is useful.