Freeze first two rows in excel 2016
In the picture above, I froze top row and first two columns, and for that, I have selected the cell that lies below the top row and next to the second column. It will freeze all the row above the selected cell and all the columns to the left of the selected cell. Then under Freeze Panes, drop-down options click on Freeze Panes. You have to select a cell in the Excel sheet which exactly lies below the rows and next to the columns you want to freeze. Step 4: Now, if you want to freeze rows and columns simultaneously. Note: You can not select Freeze Top Row and Freeze First Column simultaneously. Step 3: Under Freeze Panes You have three options Freeze Panes, Freeze Top Row and Freeze First Column.įreeze Panes: It combinely freezes rows and columns that appear above and to the left of the selected cell respectively.įreeze Top Row: This freezes top row of the Excel sheet.įreeze First Columns: Freezes the first column of the Excel Sheet. Step 2: Go to the View tab and under Window group click on Freeze Panes drop-down button. In the image below you can see that I have an Excel sheet of which I want to freeze top row and first two columns. Step 1: Open an Excel sheet on your screen, of which you want to freeze rows and columns.
#FREEZE FIRST TWO ROWS IN EXCEL 2016 HOW TO#
So, let us learn How to Freeze Rows and Columns in MS Excel 2016? Steps to Freeze Rows and Columns in MS Excel 2016: Frozen rows and column will appear, no matter wherever you are on the sheet. The best way to retain rows and columns is to freeze them. Same is the case with column if you scroll the sheet rightwards the columns to the left will be invisible. It will make no sense of reading data without headings. To read the data at the bottom of the sheet, if you scroll the sheet upward, the headings that lie in the top row will be invisible. Need more help? Just call the experts on our Remote Support Team and they will be happy to help you out in real-time with all of your technology questions.Suppose, you have an Excel sheet that contains a lot of data. Be sure to check back next week for more time-saving technology tips. This is just one of the many Microsoft Office features that make navigating a project easier. When you’re ready to unfreeze your rows and columns, simply select any row or column and then go to the View tab. With your selected rows now frozen in place, you will be able to scroll up, down, and sideways in your spreadsheet without having your needed columns or rows move off screen. From here, click on the first option, Freeze Panes. Next, go to the View tab and click Freeze Panes. To freeze a row or column in Excel, select the cell that’s in the first column and row that you don’t want to be frozen. When you think about it, this Excel feature is kind of like a grown-up version of freeze tag. It can be maddening to try and cross-reference a certain row or column on one side of the spreadsheet with another that’s offscreen.Įxcel’s freeze feature resolves this pain point by freezing a selected row or column into place, allowing you to scroll off screen while having your needed row or column locked into place. Once a spreadsheet grows to be larger than the screen, it can become tricky to navigate. By taking advantage of tools like Excel’s freeze feature, workers can make the most of their time by navigating a spreadsheet more efficiently. Many office workers feel like they live in Microsoft Excel, spending hours using spreadsheets to enter data and crunch numbers.