Course Content

Course Content

Freezing Workbook in MS Excel

How to freeze rows and columns

Now in this video we will see that how we can freeze rows and columns in MS Excel.

Suppose we have thousands of data in our Excel sheet and we want to scroll down and see our particular record but if we do that we can't see the main row which was denoting the headings. So in that case to freeze the main row we can use freeze top row option from our VIEW tab.

Now suppose if we do not want to use this option, than we can unfreeze this option from same place.

Similarly we can freeze our first column, by using freeze first column from 'Freeze panes' column in VIEW tab.

So this is how we can freeze any row and column in our MS Excel sheet.

Now in any case we want our first row and first two columns to freeze all together, than for that we will select the adjacent cell of both column and main row and use freeze pane option from VIEW tab.

This is how we can do our required work. This does not effect in print, it is just for easy visibility to the user.


FreezeSheets in Excel gives you a way to lock one row or one column at a time. When you freeze rows or columns, it locks the row or column on the current page only. Freezing only the top row, first row, or all rows and columns can be helpful to prevent accidental changes that would interfere with your data. It's a handy tool to have in Excel for those who need a more secure option. To Freeze rows and columns:To lock one row in your spreadsheet, choose the View tab in the drop-down menu, then click Freeze Top Row. To lock more than one row or column, or to lock both rows and columns at the same time, use 'View' on your menu bar at the top of your screen. Click on 'Freeze Panes'.

The freeze tabs feature in Excel can be used as a tool to quickly copy/paste cells and rows of information. This tool is helpful when working with large spreadsheets. There are a few steps that you can take to freeze tabs in Excel. First, open up your Excel document. Second, find the tab that you want to freeze and then click on the tab down button until it looks like a squiggly line. Third, right-click on the new squiggly line and select Freeze from the pop-up menu. Fourth, save your work and close it down.

Excel 2016 has a new feature called ‘Formulas Lock’, which lets you secure a formula by clicking on the lock icon on the formula bar. This is useful for preventing accidental changes or editing that may lead to incorrect results. Once you have locked a formula, the only way to edit it is with the ‘Unprotect Sheet’ command from the Developer menu. we will look at three different methods to lock a formula in Excel 2016. Method 1: Using the 'protect' button on a tab of an active sheet. Method 2: Using the Protected Sheet option on an active sheet. Method 3: Using protection on a specific cell.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere