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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |