In Excel 365, when you freeze panes in the middle of a sheet, scrolling back does not unfreeze the columns. This can be quite annoying, especially when working with large datasets. However, there is a workaround for this issue.
Understanding the Problem
When you freeze panes in Excel, the rows or columns that you want to keep visible at all times are locked in place. This is useful when you're working with a large dataset and want to keep track of column headers or row labels.
However, when you freeze panes in the middle of a sheet, Excel does not allow you to scroll back beyond the frozen area. This can be problematic if you need to access data that is located before the frozen area.
Workaround for the Problem
The workaround for this issue is to split the worksheet into two or more sections. Here's how you can do it:
- Right-click anywhere within the worksheet.
- Select "Split" from the context menu.
- This will create a vertical split in the worksheet. You can now move the split to where you want it.
- Freeze the panes as required in each section.
- To scroll back in the section that contains the frozen panes, click and drag the split upwards.
- To scroll back in the other sections, simply use the scroll bar.
By splitting the worksheet into multiple sections, you can freeze the panes as needed in each section and still be able to scroll back in the other sections.