How Do You Freeze Tabs & Lock a Formula 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.

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.

Course Content

What is MS Excel

Menu in Excel

How to Use Forums to Ask Questions

Quick Access Toolbar

Formula Bar in Excel

Status Bar in MS Excel

Navigation in MS Excel

Shortcuts in MS Excel

Format Painter in MS Excel

Data Entry

Data Entry in MS Excel

Autofill in MS Excel

Data Entry for Date-Time in MS Excel

Undo-Redo in MS Excel

Comments in MS Excel

Saving File in MS Excel

Creating Formulas

Creating Formula in MS Excel

Copy Formula in Excel

Till Date Formula in MS Excel

Pct Calculation in MS Excel

Absolute in MS Excel

Sum Average in MS Excel

Other Common Functions In MS Excel

Formating

Formatting Fonts in MS Excel

Adjusting Rows & Columns in MS Excel

Alignment in MS Excel

Formatting Borders in MS Excel

Formatting Numbers in MS Excel

Formatting Date-Time in MS Excel

Conditional Formating in MS Excel

Formatting Tables in MS Excel

Formatting Shapes in MS Excel

Adjusting Layout

Resizing Row & Column in MS Excel

Hide-Unhide Row and Column in MS Excel

Copy, Move, Insert Data in MS Excel

Find Replace in MS Excel

Print

Printing in MS Excel

Page Break Preview in MS Excel

Page Setup in MS Excel

Charts

Creating Charts in MS Excel

Types of Chart in MS Excel

Formatting Charts in MS Excel

Chart Elements in MS Excel

Sparklines in MS Excel

Adjusting Workbook

Freezing Workbook in MS Excel

Splitting Sheets in MS Excel

Outline in MS Excel

Multiple work books

Manage Multiple Workbook in MS Excel

Working with Sheets in MS Excel

Copy & Delete Sheets in MS Excel

Use of Formula in Worksheet

Edit Links in MS Excel

If condition VLOOKUP

If Condition in MS Excel

VLOOKUP in MS Excel

VLOOKUP Exact in MS Excel

COUNTIF in MS Excel

Protecting sheets

Protecting Sheets in MS Excel

Securing Workbook in MS Excel

Password to Workbook in MS Excel

Sharing Workbook in MS Excel

Track Changes in MS Excel

Data Management

Sorting in MS Excel

Subtotals in MS Excel

Filter in MS Excel

Split Data in MS Excel

Flash Fill in MS Excel

Remove Duplicate in MS Excel

Data Validation in MS Excel

Pivot Table