Tuesday, July 28, 2020

Freeze Panes in Excel

Freeze Panes    :

Keep rows and columns visible while the rest of worksheet scrolls (based on current selection).
    
It will keep the left side columns and rows data while moving right  and It will keep the top side columns and rows data while scrolling down also

Freeze Top  Row    : 

Keep the row visible while scrolling through the rest of the worksheet
    

It will keep the headers while scrolling down also

Freeze First Column    :

Keep the first column visible while scrolling through the rest of the worksheet
    
It will keep the first column while moving right also

No comments:

Post a Comment

Fetch Members from Workgroup

  import java.util.ArrayList;   import java.util.Iterator;   import java.util.List;   import sailpoint.api.ObjectUtil;   import sailpoint.ob...