Skip to main content

How to Lock Rows/ Columns in Excel?





When you are preparing a large statement or table in Excel, the column headings at the top usually disappear when you scroll down. And this is really troublesome when you need to input data under several headings. Couple of months ago, I faced the same problem. And just 2 days ago, one of my relatives questioned me how to create static/ fixed column header in Microsoft Excel. 


Then I explored the topic and found the solution from Excel help and Microsoft Support Page. So, in this post, you are getting another important excel tutorial - How to Lock/ Fix/ Freeze Rows or Columns in excel while scrolling throughout the worksheet.


Lock/ Fix/ Freeze Rows or Columns

In Excel, the term is known as Freeze Panes. With this option, you can freeze a row or column that you want visible even when scrolling down or right. 

Suppose, you preparing a salary sheet that contains hundreds of rows. And you can view only 25/30 rows in a view. When you scroll down, the column headings will disappear. If you want the first row (that contains headings) visible, you have to use the Freeze Panes option. 


If you're using Office 2000/ XP/ 2003, you will get the freeze panes option under Window menu. 

  1. Simply open a worksheet
  2. Choose the row you wanna freeze
  3. Then go to the Window menu
  4. Hit on the Freeze Panes option - Done! 
If you want to unlock the row, follow the steps again, and this time you will get unfreeze option. 


For Office 2007/ 2010/ 2013

Here you will get the freeze panes option under View tab in Window section. And you can also freeze both top row and left column! 



Excel 2010 Freeze Panes under View Menu


  1. Open a previously saved worksheet or create a new one.
  2. Input your necessary data.
  3. Go to the View Tab.
  4. Find the Window section at the right and locate Freeze Panes
  5. Hit on the down arrow, you will get 3 options - Freeze Panes, Freeze First Column, Freeze Tip Row.
  6. Freeze Panes - Used for locking multiple rows. And the next two are used either to lock  only the first column or first row.
  7. If you want to unlock the locked row or column, you have to unfreeze it by following the same steps. 

Note: Suppose you wanna freeze first 3 rows. Then you have to click on the 4th row. Now go to the Freeze Panes option in view menu and use Freeze Panes. 





I've also uploaded a sample sheet which you can download from the above link. Download and open the above sample sheet. It contains the example of freezed panes. 

In the first sheet, I've freezed a single row. In the second sheet, I've freezed multiple rows. There you will see, first three rows are freezed. To do it, you have to put your cursor in the 4th row, then you have to choose Freeze Panes


Hope this will be helpful for you. In my next post, I'm gonna discuss about - how to print the headings in every page


Reference: Freeze or Lock Rows and Columns



Stay with Marks PC Solution to get more interesting IT topics!


Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...