how to freeze first two rows in excel 2016

Freeze 2 Columns Using Freeze Panes Option in Excel.What if we wanted t to have the first two columns of ID and name to be visible regardless of how further right we scrolled? We can ensure this by freezing the said columns in excel. Scrolling in excel from left to right moves everything. This dataset, therefore, contains student IDs, names, and their respective scores. The sample excel sheet below explains the entire procedure in the picture form.Ĭonsider data showing student scores. This option will freeze or rather lock the two columns in a way that they will always remain visible even after scrolling down. Click on freeze panes to reveal the list of options, select the first option which is freeze panes. Note to freeze two columns you need to select the third column.Īfter you are done with the selection, go to the menu bar, and select on view. In this case, we are going to select two columns because they are the ones we are interested in at the moment. The second step is to select the columns you wish to lock. If you do not have the data set to work on, open a blank excel sheet from Microsoft Excel on your laptop and insert some columns with data in them as in the case below. To do freezing is not a hard thing do, with the help of the following steps, you can freeze your work that is rows and columns at your convenient pace.įirst of all, you will need to have the data set in an excel sheet that you would like to freeze the columns. This function helps the user keep a track of important data because it will always appear visible on the screen. When data is on freeze function, it is made all visible throughout the entire sheet even when you scroll to the bottom cell of your data. We do freezing with the help of the freezing tool located under the view menu on the menu bar. Excel sheets provide its users with the function or the tool to freeze rows, columns, cells, and panesįreezing is the general activity of locking columns and rows in a given excel sheet so that when you happen to scroll top to down your rows or columns remain visible. In excel sheets we freeze columns, rows, or cells to make them visible all through the entire excel sheet even when we scroll from top to bottom.

How to freeze first two rows in excel 2016