Excel Ze Top Row How To Freeze Rows

However, be careful as doing so some of your rows (i.e. the ones before Row 13) will be hidden.

If you are using a 15-inch laptop to do this, then as soon as you go to the 25 th row or later you lose the context of which column is for which subject.

All of this happens because your header or first row is not fixed and keeps changing as you scroll down.

Excel Ze Top Row How To Freeze Rows

In this post we are going to help you on how to freeze rows or columns in excel.

Freeing in excel will turn some cells (rows and or columns) to be stagnant and these cells would not change if you move left or right or scroll up or down.

We have listed all the methods below, if you do not want to go through the entire post then you may directly click on the type of excel freeze option you are looking for: Freeze First Row Freeze First Column Freeze Panes Freeze Multiple Rows Freeze Multiple Columns Freeze Rows Columns at same time Along with helping you on how to freeze in excel, we will also help you to unfreeze and troubleshooting issues that you might encounter: Unfreeze Panes Freeze panes versus Splitting Panes Freeze Pane is Disabled Freeze First Row: This feature could be used to freeze a particular row or header that you would need to refer every time while working on excel.

Open the sheet where in you want to freeze any row header, as an example we would like to freeze the top row highlighted in yellow Now, navigate to the View tab in the Excel Ribbon as shown in above image Click on the Freeze Panes button Select Freeze Top Row option If you would like to freeze any other row, then scroll down and make that row appear as first in your sheet and then repeat Step 2 to 4.

Thats it. You are all set now.

As seen in above image you can now scroll to any corner of the page and you would see that the top row remains intact all the time without any change.

Please note that this option works as long as first row in excel is the one that you really want to freeze.

If you have scrolled in the middle of the sheet and Row 30 is appearing as first row, then this option would freeze Row 30 and not Row 1.

Additionally, if you are geek and would like to do it directly using a keyboard shortcut, then please press Alt W followed by F and then R.

Please note that this is not an in-built shortcut, rather its the same thing from keyboard as we do from mouse.

Freeze First Column: This feature could be used to freeze a particular column that you would need to refer while working on excel.

Open the sheet where in you want to freeze the column, as an example we would like to freeze the column A Product Now, navigate to the View tab in the Excel Ribbon as shown in above image Click on the Freeze Panes button Select Freeze First Column option If you would like to freeze any other column, then move right or left and make that column appear as first in your sheet and then repeat Step 2 to 4.

As seen in above image you can now move to most right corner of the page and you would see that the first column sticks there.

Please note that this option works as long as first column in excel is the one that you really want to freeze.

If you have shifted right in the middle of the sheet and Column M is appearing as first row, then this option would freeze Column M and not Column A.

If you would like to do it directly using a keyboard shortcut, then please press Alt W followed by F and then C.

Freeze Panes: This feature could be used to freeze multiple rows, columns or both at the same time.

However, this could be done only for the consecutive rows or columns.

Freeze Panes Multiple Rows: Open the sheet where in you want to freeze the multiple rows, keep the first row on top and click after the last row till where you want to freeze, as an example we would like to freeze from Row 1 to Row 13 so we will click on Row 14 Now, navigate to the View tab in the Excel Ribbon as shown in above image Click on the Freeze Panes button Select Freeze Panes option Thats it.

As seen in above image you can now scroll down and Row 1 to Row 13 will be kept intact without any changes.

You can select the range of rows from middle as well like Row 13 to Row 30, however to do so you will have to ensure that you scroll up and keep Row 13 as your first row in the sheet and repeat the steps listed above.

However, be careful as doing so some of your rows (i.e.

Row 13) will be hidden.

Excel For Mac Freeze Top Row