![]() ![]() This tutorial has shown four techniques for freezing multiple columns in Excel. This way, we do not have to keep scrolling back to the row headers to see what a value means. In this tutorial, we have learned how to freeze columns to keep them visible while we scroll to another area of the worksheet. The Split button becomes transparent, indicating that it is inactive. The split line is removed from the worksheet, and the two panes collapse into one. If you want to remove the split, click on the Split button to deactivate it. ![]() In this case, we can split the Excel screen into two panes, where the first pane has the columns I want to freeze in its place, while the second pane can be used to scroll the data We can then scroll the worksheet in the second pane, and the columns we want to remain visible will remain visible in the first pane.īelow is a dataset that extends till column V, and I want to have the first three columns always visible on the screen when I scroll to the right. Let me show you an innovative way to lock the rows or columns in their place while you can scroll and look at data that’s far off in your worksheet.Įxcel’s Split option allows us to divide the window into different panes that scroll separately. Method #4: Keep Multiple Columns Visible Using the Split Option But if you want to do this in one or two worksheets only, then you are better off using the keyboard shortcut or the Freeze Panes options in the ribbon. For example, if you want to freeze columns in multiple worksheets for all the worksheets in your workbook, then the VBA method would be helpful. Note: VBA method to freeze rows or columns in Excel is suitable only when you have to do this quite often. In case you want to freeze multiple columns in all the worksheets in your workbook, you can use the below code: 'Code developed by Sumit Bansal from You can also modify the above code to freeze one to multiple rows as well (or both rows and columns) In case you want to freeze the first two columns, you can use Columns(“C:C”).Select In the above code, I wanted to freeze the first three columns, so I used Columns(“D:D”).Select in my code. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |