Explain in detail the utility of freezing worksheet columns and rows.

Freezing worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.Normally,when you scroll down or to the right,the column content in the top rows and the row content in the leftmost columns no longer appear on the screen.When the content of these rows and/or columns helps to identify or define other content still visible on the worksheet,it can make it difficult to remember what the numbers in the visible cells represent.To alleviate this problem,Excel allows you to freeze columns and rows so that Excel displays their content on the screen no matter how far down or to the right you scroll.