read more can be viewed at any point of time, one need not go back to them again and again. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell. Rows and columns make the software that is called excel. Moreover, since these rows and columns Rows And Columns A cell is the intersection of rows and columns. Hence, by freezing panes, the user knows the kind of data contained in these fixed rows (1, 2, and 3) and columns (A, B, and C). Rows 1, 2, and 3 and columns A, B, and C are frozen. Click the “freeze panes” drop-down from the View tab of the Excel ribbon.Freezing panes is helpful when the dataset is large and there is a need to view certain sections of the data at all times.įor example, to freeze the first three rows and the first three columns of a blank Excel worksheet, we undertake the following steps: Freezing panes in excel helps freeze one or more rows and/or columns so that they remain fixed while scrolling through the database.
0 Comments
Leave a Reply. |