That's my belief, yes. Now, there is something else you can do that may satisfy your needs: You can split the display into vertically and/or horizontally, and scroll to a different part of the worksheet in the top/bottom or left/right portions of the screen. This would allow you to examine in one glance, say, columns A:D and X:Z, and/or rows 1:20 and 1029:135. This isn't permanent; unlike freezing the top (header) rows and left columns you can always scroll to different parts of the worksheet. But if what you want is a temporary effect, it would probably be useful for you. And it is saved from one Excel session to the next; I have one workbook where I do it often, and it remembers the split-screen settings when I open the workbook a few weeks later. If you want to look into that, look for Split in the ribbon's View tab.
|