Under the View menu, select the freeze panes command. The final step is now to apply the freeze command on the selected rows. We can select three rows for this case and try to freeze them. To select, place the cursor on the rows and click and drag over the rows. This is the step where you highlight or select the rows that you would like to freeze. These data should have multiple rows on them. To do this, open Microsoft Excel from your computer or laptop. Record some data into an excel sheet if you do not have any existing data records to work on. This function helps the user keep a track of important data because it will always appear visible on the screen.Ī couple of steps are followed when we need to freeze the multiple rows in the excel sheets these steps include some of the following. Once it is active your data will remain visible.įreeze is the act of locking the rows or columns in a particular excel sheet to keep the values in the rows or the columns always visible all through the excel sheet. To make these data always visible in excel sheets, we have a command referred to as the freeze command. Some of the benefits of Excel are that it gives you some of the functionalities and capabilities to make your data always visible throughout the excel sheet. People use to record data about multiple findings from various studies, store data, and arrange their work neatly. People in nearly all the parts of the world have now learned and adopted the use of excel sheets in their day-to-day activities.