For the Address example, we would click on Row 3 because we want to view Rows 1 and 2. Select the Row under the rows you would like to freeze by clicking on the row number to the left of each row.You could freeze both Row 1 and 2 to keep all headers visible. This type of data would have “Address” in Row 1 merged across several cells and Row 2 would have “Street Address”, “City”, “State”, etc. How To Freeze a Row In Excel: A Simple Example It is highly useful when there are more categories or subcategories in the header rows. This allows you to keep several rows frozen while you navigate through the rest of the data. Under the VIEW tab on the top menu bar, you may select FREEZE PANES and you will see three options for freezing sections of data.įreeze Panes excel is the first option. The ability to freeze rows in excel will prevent having to scroll up and down repeatedly to view the column titles of the data or similarly to freeze columns in excel will prevent the constant sliding back and forth horizontally. Excel now allows more than a million rows and over 15,000 columns so, needless to say, workbooks can become extremely large and difficult to navigate. It is very useful when working with a lot of data. It keeps the row visible while you scroll through the rest of the sheet. Here we have 3 easy steps that help you understand how to freeze cells in excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |