As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Lock Rows and Columns in Excel

When working within Excel, you might frequently find yourself navigating through extensive data. Freezing rows and columns becomes a handy feature, ensuring easy access to essential information without constant scrolling.

Freezing Rows in Excel

To freeze rows in Excel, choose the row below the one you want to lock. For instance, to freeze row 1, select row 2. Then, navigate to the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze Panes from the drop-down menu.

Freezing Multiple Rows in Excel

If you need to freeze more than one row in Excel, select the desired consecutive rows. For example, to freeze rows 1 and 2, select row 3. Access the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze Top Row from the drop-down menu.

Freezing Columns in Excel

To freeze columns in Excel, select the column to the right of the one you wish to lock. For instance, to freeze column A, select column B. Then, go to the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze Panes from the drop-down menu.

Freezing Multiple Columns in Excel

If you wish to freeze more than one column in Excel, select the consecutive columns you desire. For example, to freeze columns A and B, select column C. Access the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze First Column from the drop-down menu.

Locking Rows and Columns Simultaneously in Excel

To lock rows and columns in Excel, select the cell positioned below and to the right of the row and column you intend to freeze. For instance, to freeze row 1 and column A, select cell B2. Then, access the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze Panes from the drop-down menu.

Locking Multiple Rows and Columns in Excel

If you want to lock multiple rows and columns in Excel, select the desired consecutive rows and columns. For example, to freeze rows 1 and 2 along with columns A and B, select cell C3. Access the View tab on the ribbon and click Freeze Panes in the Window group. Choose Freeze Panes from the drop-down menu.