Thread: [Solved] How do I frozen a certain part of a worksheet?
View Single Post
 
Old 12-15-2013, 10:15 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In any version of Excel, you can scroll the worksheet so that the top-left corner of the area you wan to view is at the top-left corner of the active window. You can then click on another cell and use Freeze Panes to 'lock' the screen such that the area bounded by the top-left corner of the active window and the 'other' cell cannot be scrolled out of view. You also have the 'Split' option, which allows you to scroll each of the windows independently.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote