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

Content Assist set up in Eclipse

# Open the Eclipse application # Navigate to Windows > click on Preferences # Navigate to Java and expand it # Navigate to Editor a...