![]() Select Freeze Panes from the view options.Here are a few examples of Freeze Panes in Excel: In the next few paragraphs, we will learn how to use the features associated with freezing panes and using them for analysis. The Freeze Panes feature is not very complicated to use if we know the database we are working with. The Grey Lines in the middle of the worksheet indicate where the rows and columns have been frozen in place. ![]() Freezing Panes also enable us to split the dataset into multiple parts to ease analysis: The worksheet gets split into different parts, which can be browsed independently. The figure above compares the same dataset with and without the first column frozen in place. A frozen first column to know which record we are evaluating for a particular parameter.This makes it easy to know which parameter we are referring to when analysing data beyond the first few records in the workbook. This shows how the same dataset looks like with a frozen row. A Frozen top row to know which parameters we are looking at during a review:.Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |