Working with a large number of data, the worksheet becomes unmanageable. When you go through the rest of the worksheet, other columns and rows will not be visible on the screen.

In this video, I demonstrated how to freeze columns and rows that you want to be visible while you are scrolling and going through the rest of the worksheet. Hiding and unhiding of rows and columns are also part of this tutorial.

#HowToFreezePane
#HowToHideColumnsAndRows

Follow me on my Facebook page for training services: www.facebook.com/SirMonPeralta

Please take the opportunity to connect and share this video with your friends and family if you find it useful.