Articles → EXCEL → Freezing Panes In Excel 2007

Freezing Panes In Excel 2007








Software Requirement





Prerequisite Knowledge





Freeze Panes






  1. Select any row/column
  2. Go to ‘View’ option
  3. Select ‘Freeze Panes’ drop down
  4. Click on ‘Freeze Panes’
Picture showing the Freeze Panes menu option inside the View tab in excel

Click to Enlarge



Picture showing the output of freezing panes in excel

Click to Enlarge


Unfreeze Panes




  1. Go to ‘View’ option
  2. Select ‘Freeze Panes’ drop down
  3. Click on ‘Unfreeze Panes’
Picture showing the Unfreeze Panes menu option inside the View tab in excel

Click to Enlarge




Freeze Top Row And First Column




Picture showing the freezed first row in excel

Click to Enlarge



Picture showing the freezed first column in excel

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Thursday, June 26, 2014

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250