Freezing Microsoft excel rows
I know we can select the 3rd row and go to view-> freeze panes -> freeze panes option to lock the excel sheet till 2nd row. But my doubt is, when i FILTER out the column my 2nd row dissappears and only first row is showing. So, How to lock(freeze) the excel sheet while filtering out columns?
AMOGHA. A. K. Have u read my question. I'm facing problem while filtering the column. Not while scrolling. Anyway thanks for the try