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.

FAQs

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.