How to freeze rows and columns in Excel?

The instructional exercise shows fast approaches to solidify sheets in Excel. You will figure out how to rapidly lock or freeze rows and columns in excel. You will likewise perceive how to solidify a few sheets at an opportunity to make Excel dependably demonstrate certain lines or/and sections when you look down or right. These tips work in every single present version of Excel 2016, 2013, 2010 and 2007.

How to freeze rows in Excel?

Normally, you would need to freeze the main line to see the section headers when you look down the sheet. In any case, at times your spreadsheet may contain critical data in a couple of best columns and you might need to solidify them all. Underneath you will discover the means for the two situations. Let’s look at them one by one.

How to freeze the Top row in Excel?

You can easily freeze top row of your Spreadsheet by just following these simple steps below:

  1. Click on the View tab of the header of your Excel Window, then move to the Freeze Panes and select Freeze Top Row.

Freezing the top row in Excel

And once you freeze your top row, It would appear in bold to let you know that it is frozen.

A darker border indicates that the row above it is frozen.

Now, you must be wondering that It is very simple to freeze the top row of your spreadsheet but what if you want to freeze multiple rows in your Spreadsheet, How would you do that. So, Here is How!

How to freeze multiple rows?

  • To easily freeze multiple rows in your Spreadsheet, you first need to click on View tab.
  • Then move towards the Freeze panes and Select Freeze panes to freeze multiple rows, but before that select the row next to the row you want to freeze in your Excel sheet. Like this,Select the row below the last row you want to freeze and click Freeze Panes.

So, Now the top two rows of your Spreadsheet are frozen, as you can see in the screenshot below,

A darker border indicates that top 2 rows are frozen.

Now, Let’s look how can we do similar things with columns.

How to freeze columns in Excel?

It is done exactly like we have done in feezing the rows, you can either freeze the top column or multiple columns according to your choice.

Let’s try it practically,

  • To freeze the first column, you just need to go to VIEW tab, and then from “Freeze Panes”, you need to select the Freeze First Column option to get your first column frozen.

Freeze the first column in Excel.

And your First Column border gets a little bit thick and darker in color.

A darker border means that the column to its left is frozen.

Now, moving towards freezing multiple Columns in a Spreadsheet, you just need to follow these simple steps.

  • Select Freeze Panes from View tab and then click on the Freeze Panes.
  • Here, before selecting freeze pane, Select the column right to the column you want to freeze up to, Like this,

Freezing several columns in Excel

So, This is how you do freeze the rows and columns in an Excel sheet. If you had a good time reading and learning from this article, refer this website to learn more excel tips and tricks to your friends and colleagues. If you have any queries regarding this article, write it to us, we would be happy to help you.

Add a Comment

Your email address will not be published. Required fields are marked *