how can i freeze first two rows in excel

This will automatically freeze and lock the very first column in your document. Click on the Freeze First Column icon.The freeze is indicated by the bottom line of the row becoming darker than other lines, showing that the row is currently frozen.This will automatically freeze and lock the very first row in your document. Switch to the View tab in your Ribbon interface, located on top of the Excel window.

Open the document you want to work on in Excel.After opening Excel and the document you’re working on, switch to the View tab in your Ribbon interface, and make sure that the Normal view is selected.Īfter completing this, you can proceed with the appropriate steps described below. Freeze rows and columns in Excel for Macīefore you can start freezing and locking, you need to ensure that you’re in the right view mode. This article goes in- depth about all aspects of freezing a row, column, or cell to make your life easier when working with the leading spreadsheet application for Mac systems. Make finding important data or comparisons easier by taking advantage of this feature on Excel for Mac. Frozen (also referred to as locked) rows, columns, or individual cells stay on your screen even while you’re scrolling, allowing you to create headers and key data entries.

Freezing a row or column in Excel is a great way to not only improve the design of your spreadsheet but its functionality as well.

How can i freeze first two rows in excel