What is freezing and how can we freeze the rows and columns. Mention the steps.
Share
What is freezing and how can we freeze the rows and columns. Mention the steps.
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Answer:
To freeze both rows and columns, select the upper left cell in the data you don't want to freeze. Then choose Freeze Panes from the menu. Now the rows above this cell, and the columns to the left of this cell will be frozen, and remain visible as you scroll. Choose Unfreeze Panes to reset.