how do you freeze first two rows in excel

Step 1: Open your Microsoft Excel file that contains the rows that you wish to freeze. The steps in this section were performed in the Office 365 version of Microsoft Excel, but will work in most other versions of Excel as well. How to Float Two Rows at the Top of the Screen in Excel Related: This article on how to apply shading in Excel will show you one method for making it easier to find data. Our guide will show you how to freeze two or more of your worksheet’s top rows so that they remain fixed at the top of the page when you move further down the worksheet.

But what if you want to keep many rows displayed at the top of the sheet instead?įortunately, you can achieve this as well by using the option to freeze a pane. In an Excel spreadsheet, creating a row of headings to identify your columns is a popular technique to organize data.īut, as you scroll down and the header row is no longer visible, it can be difficult to recall which column carries which data.įortunately, you can freeze the top row of your spreadsheet to keep it at the top of the page. But, if you have several rows at the top of the spreadsheet that you want to stay accessible, you may be asking how to freeze several rows in Excel 2013. Utilizing header rows in spreadsheet tools such as Google Sheets or Microsoft Excel makes identifying information much easier. Our guide continues below with additional information, including pictures of these steps. Click Freeze Panes, then Freeze Panes again.6 Frequently Asked Questions About Excel Row Freezing How to Freeze Multiple Excel Rows

How do you freeze first two rows in excel