#How to freeze top 3 rows in excel 2010 how to#

If you want to freeze top row only that mean you want to visible top row while rest of the rows are scrolling. Step 2: To start freezing process click on the вЂњFreeze PanesвЂќ command which is placedВ in the вЂњViewвЂќ tab.В You can use also use anyВ required option for freezing like Freeze panes, Freeze Top Row and Freeze First Column.В TheseВ three options available during freezing the row or columns. Step 1: Open an existing large worksheet in which you have number of records. If you want to take benefit of freeze command in Excel then you just have to take following given easy steps: You have to use following given steps to freeze or lock rows and column in excel.

#How to freeze top 3 rows in excel 2010 how to#

How to freeze or lock rows and columns in Excel at the same time: After that you will be able to easily check out active worksheet data in which particular portion is fixed while rest of the part is scrolling. This article helps you to easily solve your problem. Lot of time we need to freeze or lock rows and columns in Microsoft Excel at the same time but we donвЂ™t know how to do this. Freeze command is very useful command to check out your large worksheet data.

Must Read: How to adding a leading zero value in MS ExcelДЇreeze panes allows you to lock or freeze any particular portion of the active worksheet which is visible while rest of the part is scrolling. These features and functions help us to solve any complex problem. There are lot of features available in MS Excel. This article helps you to easily understand how to take benefit of freezing or locking facility in MS Excel. Now, if you have a large amount of worksheet data and you want to freeze or lock rows and columns in Microsoft Excel at the same time then you have to read this article. There are lot of ways to freeze or lock any row, column as per you need. I will helps to you easily manage or view large worksheet data from a particular row and a column. Lot of time you need to freeze or lock rows and columns in Excel at the same time. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.All we know very well about the MS Excel. Note: to unlock all rows and columns, click the Freeze button again. Scroll down to the rest of the worksheet. To freeze the top row, select row 2 and click the magic Freeze button.Д§. Under Choose commands from, select Commands Not in the Ribbon.Д¦. The orange region above row 3 and to the left of column C is frozen.ДЄdd the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.ДЈ. To freeze cells, execute the following steps. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen.

All columns to the left of column E are frozen. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. On the View tab, in the Window group, click Freeze Panes.Д¤. To freeze rows, execute the following steps.Дў. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. To unlock all rows and columns, execute the following steps.ДЎ.

Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.