*This post may contain affiliate links. As an Amazon Associate we earn from qualifying purchases.
An indispensable tool for keeping your Excel data organized is the freeze panes feature. It is often used to create header cells that contain a title for each column. This allows you to easily scroll around your worksheet without losing track of what you are looking for. Follow these step by step instructions to learn how to freeze cells in Excel.
How to freeze cells in Excel in 7 easy steps
- Open the Excel worksheet you are working on.
- Decide which row you would like to freeze. This can be a row you would like to use as a header row or any other data you would like to pin to the top to compare it with other rows on the worksheet.
- Select the row by clicking on the row’s number on the left side of the screen. A solid outline will around the row you have selected.
- Click the view tab on your ribbon menu.
- Select the Freeze Panes drop down menu.
- Select the first option: Freeze Panes.
- Scroll up and down the worksheet to ensure that the row is frozen in place. If you have mistakenly chosen the wrong row, simply select Unfreeze Panes from the same drop down menu.
You can use this feature to freeze a single row or multiple rows at the same time. Rows can be frozen and unfrozen as many times as you want without modifying their data which is a useful tool if you want to compare different rows of information with each other. This feature cannot be used with the top row of your spreadsheet. If you want to freeze the top row, select Freeze Top Row from the Freeze Panes dropdown menu. You can find more information on this feature and other articles about Excel the official Microsoft Office Support Website.
Do you have any questions or feedback about how to freeze cells in Excel? Please share your experience with us.