How to freeze 3 Rows in Excel

How to freeze 3 Rows in Excel

Row headings are very useful when working on your spreadsheet. You can quickly look at it while working to know the data that are contained in each row. Imagine if you are working on a file that contains large data. You will still down, and you may not be able to view the row header again. Scrolling up to check can be very cumbersome, and you will waste lots of time. You can scale through this challenge by freezing the top rows to view them even when you scroll down. The frozen rows will remain fixed and move as you move.

The ”freeze a pane’ option on excel will assist you in this task. Here is a tutorial on how to freeze three rows on your excel worksheet.

Freezing of three rows on Excel spreadsheet

This guide will show you a step-by-step approach in freezing the top 3 rows in Excel. It follows the same format as our previous article on ”How to freeze columns on excel.

This tutorial is workable for any number, but in this tutorial, we will focus on the top three rows.

1. Check the left-hand side of the excel spreadsheet. You will find the row numbers. Locate the row below the last row that you wish to freeze. We want to freeze the three rows at the top of the sheet; hence, you should click on the fourth row.

 

 

 

 

 

 

 

 

 

 

 

2. Check the top of the spreadsheet and click the ”view tab.”

 

 

 

 

 

 

 

 

 

 

 

3. Locate the navigational ribbon. When you find it, check for the ”Freeze panes button” and click on it. Go through the drop-down menu and click ”Freeze panes option.”

4. The drop-down menu might tell you to unfreeze the panes. Go ahead and unfreeze before selecting the ”Freeze panes button” again.

 

That is all there is about freezing three rows on excel. If you have done it well, a thick and slightly darker line will show below the last frozen row.

Please note that you can only freeze the top rows or columns. Freezing operation does not work for middle and bottom rows. However, you can keep a section of the spreadsheet visible by using the split option.