View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How to lock a legend on screen

If you land the cell pointer on H13 and click Window Freeze Panes, H13
becomes the axis of the frozen panes. You might then hide columns A-F,
thereby displaying column G only. Whether this will work or not
depends on what you have in A-F, and whether it must be displayed at
all times.