Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor. We can freeze the top two rows in Excel VBA also. Method 3: Freeze Top Two Rows in Excel Using VBA Freeze Multiple Panes in Excel (4 Criteria).How to Freeze 2 Columns in Excel (5 Methods).Excel Freeze Panes Not Working (5 Causes with Fixes).Read More: Keyboard Shortcut to Freeze Panes in Excel (3 Shortcuts) If you want me simplify, first press ALT+F, then F, again F. If we look closely, there is a horizontal line in row 2. Let’s see, how to do this.įirst, click on cell A3, as we want to freeze the cell above this row.Īfter that, our screen will look like the image below. We can also use a shortcut key to freeze the top two rows if we want. Method 2: Freezing Top Two Rows Using Shortcut key

Read More: How to Freeze Top 3 Rows in Excel (3 Methods) You can see the top two rows got frozen, we scrolled down to the 20th row, the row is still visible. Now, we have to click the Freeze Panes option from there.Īfter that, our dataset will look like the following image. Now, we will go to the View tab and click Freeze Panes option from there, as shown in the following image. So, the question is, how you will do this.įirst, click below the cell you want to freeze the rows. Keep in mind that this doesn't have to literally be the top row in your spreadsheet - this command lets you freeze the first visible row.4 Quick and Easy Methods to Freeze Top Two Rows in Excel Method 1: Freeze Top Two Rows Using View TabĮxcel has some in-built features to freeze any number of rows or columns.In this data set, we want to freeze the top two rows. Check out the products mentioned in this article: MacBook Pro (From $1,299.99 at Best Buy) Lenovo IdeaPad 130 (From $299.99 at Best Buy) How to freeze the top row in Excel There are two ways to do this: You can freeze the first visible row, or you can freeze a set of rows. Spreadsheets can get complicated, and frequently you need to be able to compare two different sets of data that are widely separated on your Mac or PC screen.Īn easy way to do that is to lock a row (or column), so it stays in a fixed location while the rest of the spreadsheet scrolls up and down (or side to side). Visit Business Insider's homepage for more stories.It's easy to unfreeze a row in Excel at any time using the same command.It's possible to freeze the first visible row at the top of the spreadsheet, or freeze a set of rows.You can freeze a row in Excel so it stays locked on the screen as you scroll, making it easy to compare data from different parts of the spreadsheet.

Excel how many rows can you freeze