how can i freeze first two rows in excel

In our example, we've scrolled across to column E. You can scroll across the worksheet while continuing to view the frozen column on the left. The column will be frozen in place, as indicated by the gray line.In our example, we want to freeze column A, so we'll select column B. Select the column to the right of the column(s) you want to freeze.In our example, we've scrolled down to row 18. You can scroll down the worksheet while continuing to view the frozen rows at the top. The rows will be frozen in place, as indicated by the gray line.Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.In our example, we want to freeze rows 1 and 2, so we'll select row 3. Select the row below the row(s) you want to freeze.By freezing rows or columns in place, you'll be able to scroll through your content while continuing to view the frozen cells. You may want to see certain rows or columns all the time in your worksheet, especially header cells. Optional: Download our practice workbook. Fortunately, Excel includes several tools that make it easier to view content from different parts of your workbook at the same time, such as the ability to freeze panes and split your worksheet Whenever you're working with a lot of data, it can be difficult to compare information in your workbook. en/excel2013/functions/content/ Introduction 4 min read Lesson 17: Freezing Panes and View Options.

How can i freeze first two rows in excel