Important Tip! Excel will freeze ANY row that is at the top of the window using this method. Now when you scroll up and down through your spreadsheet, the top row stays in place and the other rows pass under it.
Scroll until the row you want to remain “on top” is the very first row in the window. Here are the steps for freezing a specific row or column in your sheet: Can You Freeze a Specific Row in Excel Sheets?Įxcel gives you several ways to freeze and unfreeze data. What does that number mean? Is this the primary email address or the secondary email address? Freezing rows and columns helps keep the information you need in view on the Excel window. Why is this mentioned in a post about Freezing Rows? Imagine trying to read a sheet with the headers 1000 rows above the data you are looking at. Now, as you move towards the right horizontally, the columns A and B should stay in place while other columns should move.By Tepring Crocker Categories: Basic Excel, Excel Training, Excel® Tags: Excel, freeze data, freezing cellsĪs of 2022, Excel can contain up to 1,048,576 rows by 16,384 columns of data. Click the small arrow and press the “Freeze Panes” in the menu as shown in the graphic below. Suppose, you want to freeze column A and B, so that their content is in focus as moving horizontally to the other columns. If you navigate downwards/vertical, the column values move. Note: If you freeze the first column, it remains visible for the horizontal movement only. Similarly, you may freeze the top row by clicking the Freeze Top Row under the “Freeze Panes” menu. As you navigate towards the right, this column should always be in view for that worksheet (as shown in the above graphic). 
Open the menu by small arrow and select “ Freeze First Column”. For freezing first column and top row, the options in the menu are available straight away. 
In certain scenarios, the first column may contain sheet headers that you may want to always keep in view as navigating or working in the worksheet.Įxcel allows you to freeze the first column and top row easily. Similarly, freezing two or more columns is easy but a little trick that I will show in this tutorial. In Excel, freezing the first column (the leftmost) is pretty easy.
0 kommentar(er)
