Need to know how to lock a column/row so that other columns/rows will scroll but the ones I want to stay in place, stay in place.

Thanks.

 

You need to select the row or column next to the ones you want to stay visible whenever you scroll up or over. Once you have this column or row selected, click on Window, and then Freeze Pane.
Now, whenever you scroll, the cells within the frozen section will stay visible, while the rest of the table scrolls down or over.
To undo this, simply select Window, and Unfreeze Pane.

 

Much obliged!