This time instead of columns we will do a similar procedure on the rows of the first 4 employees. It is very similar to the first method where we freeze based on columns. In this worksheet, for instance, we might want to freeze the rows of the first 4 employees along with their information column so that we can compare them with others while scrolling down the worksheet. Sometimes we need to freeze some rows of our worksheet. Use Freeze Panes to Freeze Rows and Columns Based on Rows
#How to freeze first two rows in excel on mac serial
After selecting Freezing Panes, Serial and Employee Name columns will be frozen and two thin lines will appear above and on the right side of Serial and Employee Names We can now slide horizontally with these two columns always visible to us.Ģ. From the dropdown list, we will select Freeze Panes. Now we will select Freeze Panes from the View After selecting the Freeze Panes, a Drop-down list will appear. So, we will select these two columns or we can also select any cell on column D. First, we have to choose a column, cell, or all columns on the right side of the Serial and Employee Name In this worksheet Department and Joining, Date columns are on the right of these two columns we want to freeze. We might want to freeze the Serial and Employee Name columns of our worksheet So that we can keep seeing these two vertical columns as we are sliding horizontally. Use Freeze Panes to Freeze Rows and Columns Based on Columns We can do so by using Freeze Panes, Magic Freeze, and Splitting Panes.ġ. We might sometimes need to keep the information of some employees (Rows) or specific information (Columns) in our view to compare them with others. But as we are doing so, we need to keep the column header visible to see which type of information an employee we are looking at. As we have different information about a lot of employees, we have to slide horizontally to view the different information about an employee or scroll down to see the information about a specific employee whose information is very far down the worksheet. Imagine a case where we have an Excel worksheet with information about a company. 
Freeze Rows and Columns at the Same Time in Excel.xlsxĤ Methods to Freeze Rows and Columns at the Same Time in Excel
0 kommentar(er)
