View Single Post
 
Old 12-13-2013, 07:46 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote