Under this command there is a list of options, select the first option to freeze the rows.Īfter you select the first option, your rows will be locked or be in a freeze mode so when you scroll up and down they will always remain visible. 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. After freeze the bottom row, now, you need to freeze the top row in the above worksheet, please click one cell in the above window, and click View > Freeze Panes > Freeze Top Row, see screenshot: 6. 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.
#HOW TO FREEZE FIRST TWO ROWS IN EXCEL FREE#
I am free because I know that I alone am morally responsible for everything I do.
#HOW TO FREEZE FIRST TWO ROWS IN EXCEL PLUS#
If you click in B3 then the top 2 rows plus column A should not scroll out of view. To do this, open Microsoft Excel from your computer or laptop. Click in A3 and use Freeze Panes should freeze rows 1 and 2 in place. In the below example, columns A, B will be frozen, and the top 5 rows will be frozen also. Freeze rows and columns by assign the cell name to worksheetobject ‘s freezepanes attribute. Record some data into an excel sheet if you do not have any existing data records to work on. Get the active excel sheet ( worksheet) use Workbook.active attribute. 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. For example in our case below, we can see that the first two rows do not scroll with the rest of the worksheet.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. You will notice that the rows that you freeze remain visible or fixed even when scrolling down the entire worksheet. Only these rows that freeze remain in their fixed position while other rows scroll up and down. Now you can scroll throughout the worksheet without the freeze rows moving. This is realized after clicking the View tab on the ribbon. Step 3: Then navigate to the window group of command icons and select the freeze panes command. Step 2:Click the View tab on the Excel ribbon located at the top. In my case, I have selected the first three so that the first two rows can be frozen. For example to freeze all the top first ten rows, select the eleventh row. The rows that are to be frozen are those just above the lastly selected row. This is done by taking the cursor to the left-most side of the rows you want to highlight. It will freeze both the top row and the first column of the worksheet. As a result, the Freeze Panes menu will appear. Go to the View tab and click on Freeze Panes from the Window ribbon. Step 1: After the Opening excels, the first worksheet will be loaded. So to freeze the top row and the first column, you need to select cell B2 as the reference cell. Freeze the first column If youd rather freeze the leftmost column instead, on the View tab, click Freeze First Column. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen. However, sometimes we might not desire such phenomena. Freeze the top row On the View tab, click Freeze Top Row. Doing this scrolls all the content from the first row to the rows that we intend to arrive at. IF we needed to view the rest of the data we would have to scroll down the worksheet using the vertical scroll bars at the sides of the excel document. Worksheets are labeled with tabs and are by default Worksheets contain related data.Įach worksheet can contain too much data that even flows beyond on-page. A single entry page of cells is called a worksheet. Columns on the other hand are vertical arrangements of cells. A row in excel is a horizontal arrangement of cells. A cell is an intersection between a row and a column. Excel is a spreadsheet program that helps us manipulate data in cells.