Video: Freeze or unfreeze rows and columns

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Sometimes it is useful to freeze specific rows and columns in a spreadsheet. For example, if you have a spreadsheet that contains a large amount of data and includes headings in the top row, you might want to freeze the top row so that it is always visible when you scroll.

Watch this video to learn how to freeze and unfreeze rows and columns in a spreadsheet.

Applies To: Excel 2010

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language