If you set up a worksheet with row or column headings, these headings will not be visible when you scroll down or to. To working just fine! That is, expanding any of the groups (that are above the split) pushes the split down, and collapsing them 'pulls' the split up. Freeze Panes in Excel 2010 Freezing Panes. Add the following input parameters to this action: - Handle (Number) : The instance of the excel sessions held in the dictionary to establish the current excel connection. So keep that in mind, to avoid problems Go to the Freeze Panes feature in Excel on my Contextures site for more tips, and a sample file. Excel always freezes the top row(s) and first column(s) that are visible in the Excel window. If the issue does not occur when you restart Excel in normal mode, start enabling your add-ins one at a time until it does. Close and restart Excel in normal mode (not in safe mode). If I just delete all the grouped rows that seem to be causing the issue, I then I still have the grouping just three rows above the split, but it's back Create a new action called Freeze Panes within the MS Excel VBO object which consists of other actions. Freeze First Column and Freeze Panes work in a similar way. Clear all the check boxes in the list, and click OK. If I select cell 'D4', I expect what I have described above to happen.

For example, I want to freeze rows 1 through 3, and columns A through C. And, Excel freezes up and needs to be killed off with the I am attempting to freeze both rows and columns in Excel 2016, and I can't get the feature to work completely. I try to expand it, it doesn't 'push' the split down, like it should rather, the split stays in place, with the ungrouped rows seeming to expand 'past' the split (below it). I can collapse that group just fine, but then when I add one more set of grouped rows, with the bottom of the grouping three rows above the split. (Just one 'level' of groupings that is, no nested grouped rows.) All works just fine, except. I have a large spreadsheet, and have several groups of rows that I can freeze and unfreeze. I'm having a weird problem I can't sort out in Excel 2013.

Excel freeze panes problems