This same principle can be applied to rows, which is covered in another tutorial.
If you have many columns with data, you can scroll through them and know exactly what they refer back to at the beginning of the spreadsheet. However, its most common use will be doing what we have done in this tutorial. You will notice that all of the columns and their headings move with your mouse, except for the contents of Column A, which in our example is Type, A, and B.įreeze panes can be applied to any column. Now try scrolling your mouse to the right. That is because this line marks off the frozen cells on the left from the unfrozen cells on the right. In the screenshot, you can see that the line dividing Column A from Column B is darker than the other lines between the other columns. By selecting cell B1 and then choosing Freeze Panes, you have frozen all the cells in Column A. A bar will appear between Column A and Column B. Once you have selected cell B1, click Window > Freeze Panes. Use Normal view.įrom Normal view, select the first cell in column B, cell B1. Freeze Panes will not work in Page Layout view. Freeze Panes allows the user to freeze a column and scroll through the rest while the frozen column remains in the same place.įor our example, we will be working with a spreadsheet that lists Type in the first column, and then has further classifications about that Type in the succeeding rows.īefore we begin, make sure you are not viewing your Excel file in Page Layout view. For example, if you want to loc the first column and the first row, select the cell reference B2.This feature can be especially helpful for users who have a spreadsheet that is more horizontally than vertically oriented. In order to this, you have to follow a similar pattern, with a slight modification.Ģ. To lock rows and column at the same time, locate the cell that is right underneath and right to the columns you want to freeze. How to Freeze Columns and Rows at the Same Timeġ. Microsoft Excel also gives you the option to freeze both rows and columns at the same time. In this case, I want to freeze the first Column A so, I’m going to select the cell B2.ģ. Go to Freeze panes> Freeze panes. How to Freeze Columns in Excelġ. Select the first cell to the right of the column you want to freeze. You can now scroll down or across your spreadsheet without having to remind yourself the contents of these rows. In this case, I want to freeze the second row, so I’m selecting the third row.ģ. At the top of your Excel window, go to the View Tab.Ĥ. Tap Freeze Panes, and from the drop-down menu, select Freeze Panes.Īnd this is how simple it is. Select the row right underneath the row you want to freeze. To make sure that you don’t lose sight of your columns and headers, here’s what you have to do.Ģ.
Okay, so there are manual ways of freezing rows and columns in excel, but we’re not going to be talking about them because they’re not as effective as the built-in Freeze panes feature in Excel. Step-by-Step: How to Freeze Rows in Excel To access this feature, go to the View tab, select Freeze Panes, and Select either Freeze top rows or columns, according to your preferences. There’s an ib-build feature that makes the job a piece of cake for you.
To Freeze topmost rows and columns in Excel, you don’t have to do anything at all, tbh. How to Freeze panes in excel with Visual instructions How to Freeze Topmost Rows and Columns in Excel Note: It’s noteworthy to mention here that it is not possible to lock or freeze individual cell references in a single place. It’s something you should absolutely know if your work involves confrontation with Microsoft Excel on a daily basis. This is a huge problem when you have stacks and stacks of rows and columns and are finding it hard to navigate the Excel spreadsheet you’re currently working on.Īlso, this little Excel trick will shoot your productivity through the roofs. However, learning how to freeze panes in Excel is one way of slicing this ordeal into a manageable difficulty.įor one, it saves you from the hassle of scrolling all over the Excel spreadsheet just to locate your column and row headers. A black border should appear to the right of column A in the worksheet indicating that the area to the right of the line has been 'frozen'. Click on Freeze First Column option in the list. Click on Freeze Panes from the ribbon to open the features drop down list.
Excessive scrolling and managing rows and columns is a frustrating ordeal, to say the least. Freeze the First Column Click on the View tab. Dealing with an enormous amount of data is hard in itself.