How to freeze a row or column in Excel
• Open your spreadsheet in Excel • Select the row(s) or column(s) you want to freeze. Make sure you select the entire line of cells by clicking in the rolumn or row name at the side of the spreadsheet • Open the View tab • Click the triangle next to Freeze Panes and choose Freeze Panes from the options • If the row or column you want to freeze is the first in the spreadsheet you can alternatively choose Freeze Top Row or Freeze First Column
How to unfreeze a row or column in Excel
• Open your spreadsheet in Excel • Select the row(s) or column(s) you want to unfreeze. Make sure you select the entire line of cells by clicking in the rolumn or row name at the side of the spreadsheet • Open the View tab • Click the triangle next to Freeze Panes and choose Unfreeze Panes from the options Read next: How to find your lost Windows or Microsoft Office product key Follow Marie Brewis on Twitter Marie is Editor in Chief of Tech Advisor and Macworld. A Journalism graduate from the London College of Printing, she’s worked in tech media for more than 17 years, managing our English language, French and Spanish consumer editorial teams and leading on content strategy through Foundry’s transition from print, to digital, to online - and beyond.
