How to lock columns when scrolling in Excel

How to lock columns when scrolling in Excel

In excel when scrolling, you go through the rows moving either downwards or upwards. During the process of scrolling, you leave a row and head to the other. In that scrolling is dynamic to the visibility of rows. In some cases, you may wish to compare a row inline 10 with a row inline 40. … Read more