' go up until find a content like "Summary*" 'get the first cell on the selected row, then
If you'd rather freeze the leftmost column instead, click the View tab. Select either the column or the first cell to the right of the last column to be frozen (. Notice that the border under row 1 is a little darker than other borders, meaning that the row above it is frozen. The steps to freeze multiple columns in Excel are listed as follows. Private Sub Worksheet_SelectionChange(ByVal Target As Range) To freeze the top row and the first column at the same time, click the View tab > Freeze Panes > Freeze Panes. First, select a cell, row or column, below and to the right of the area that you want frozen. One difficulty is that to scroll up you have to click on one of the rows in the top pane. To freeze multiple columns (starting with column A), select the column to the right of the last column you want to freeze, and then tap View > Freeze Panes > Freeze Panes. Each time the selection changes, it checks upward in the first column for content like "Summary*": if the worksheet isn't already frozen to that row, it will make that adjustment. In the center of the ribbon, there is an option for Freeze Panes Excel. Click on the View tab, which can be found in the ribbon at the top of the screen.
#Can i freeze multiple panes in excel how to#
You can try this out (in the worksheet code module). Here you will find an answer to the query, how to freveze panes in excel as well as how you can unfreeze rows and columns.