How to freeze or lock header columns in Google Spreadsheet?
In google docs spreadsheet, we have an option to freeze only columns.
Freezing columns will make certain columns static while scrolling other data.
It will freeze the columns from left to right and you can freeze upto 5 columns. Use vertical scroll bar to move to the cell.
To freeze columns:
Step 1: Click View → Freeze columns → select the number of columns which has to be frozen.
As, we have selected "Freeze 2 columns" option, first two columns get freezed as shown below,